At risk flag automated

Jef Snyders

Hi all, I would like to automate my 'At Risk column' via a formula. The flag should be red

• if Due date is in the past AND
• if Status is NOT 'completed' 'or empty)

I am using this formula: '=IF(Date@row < TODAY(); Date@row <> ""; 1)', but it is not working correctly.

What is wrong with this?

Paul Newcome

You need to use an AND function.

=IF(AND(Date@row <> "", Date@row <TODAY(), Status@row <> "", Status@row <> "Completed"), 1)

Paul Newcome

You need to use an AND function.

=IF(AND(Date@row <> "", Date@row <TODAY(), Status@row <> "", Status@row <> "Completed"), 1)

Jef Snyders

https://community.smartsheet.com/discussion/comment/375694#Comment_375694

This is exactly what I need! Thanks so much, Paul!

Paul Newcome

Happy to help. 👍️