IF/AND formula based on a drop down column if the cell is blank

Hi All,

I am working on a formula to trigger my at- risk flag based on the following information.

Raise the flag if the end date column is less that 1 day away and the status column is blank or Not Started.

Here is what I have so far.

=IF(AND(Status3 = "Not Started", [End Date]3 <= TODAY(2)), 1)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!