Forum Discussion

Earl40's avatar
Earl40
Helper I
2 years ago

Help with if and statement

I am trying to write a if and statement that checks for 3 criteria. When I do it for 2 criteria it work but for some reason the third one wont work. Probably because its a date field. I tried everything ""," ", blank(), null etc and its just not working 

 

I want to check is Column A = yes , Column B = yes and Column C (date field) is blank then yes if not no 

 

My custom column formula

 

each if [#Column A" = "Yes" and [Column B] = "Yes" and and [Column C] = null then "Yes" else "No"

 

any help would be greatly appreciated

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    Earl40 what is the data type of column c, is it date or text? Not the value in the column but the data type of the column.

    • Earl40's avatar
      Earl40
      Helper I
      2 years ago

      data type is a date format incljuding time. 

  • rsbin's avatar
    rsbin
    Community Champion
    2 years ago

    Earl40 ,

    Please try this:

    if ( [Column A] = "Yes" and [Column B] = "Yes" and [Date] = null)
then "Yes"
else "No"

    Not sure why you have and repeated twice in your original post.

    Have attached a simple pbix file for your convenience.

    Regards,

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    Earl40 hard to tell why it is not working without looking at the pbix file, share it using one drive/google drive, and remove any sensitive information before sharing.