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?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!