Using an IF statement to check a flag.

Colin Samuels

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?

Dan W

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"

Dan W

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"

Colin Samuels

Hi Dan,

Thanks for the quick reply. It works and thanks for the simple explanation you gave as well.

Really appreciate it and have a great day!

Dan W

Happy to help!

You do the same.