IF & AND on two dates

Options

Hi folks,

I am looking to write a formula in a flag column based on the following logic.

IF 'Date1' is less than today, AND 'Date2' is blank, return a TRUE value

Any guidance would be greatly appreciated

Thanks in advance

Best Answer

  • heyjay
    heyjay ✭✭✭✭✭
    edited 05/09/22 Answer ✓
    Options
    =IF(AND([Day1]@row < TODAY(), [Day2]@row = ""), 1, 0)
    

    Set the Column to a flag symbol, then edit the column and enter the formula above.


    ...

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!