At risk flag automated

Jef Snyders
Jef Snyders ✭✭✭
edited 05/15/23 in Formulas and Functions

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?


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!