Using an IF statement to check a flag.

Hi Community,

I am trying to check a "red flag"in the At Risk column if a task is showing "Not Started" in the Status column and the start date has past. I have the current formula but it is giving me an error. Any ideas?

Best Answer

  • Dan W
    Dan W ✭✭✭✭✭
    Answer ✓

    If you want the flag to show up in the status if it is Not started, then you will want to have "Not Started" in your formula,

    =IF(AND([start date]@row < TODAY(), Status@row = "Not Started"), 1, 0)

    Either way, using "" makes the formula look for text. So in your current formula you would change Complete to "Complete"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!