Automating at Risk Flag

Caitlin Goodman

Hi All,

I'm a total newbie to Smartsheets and need some help.

I'm trying to automate my At Risk Flag. I need it to flag projects a month from their due date if they are 50% or less complete.

Thank you!

Paul Newcome

Try something like this...

=IF(AND([Due Date]@row <= TODAY(30), [% Complete]@row <= .5), 1)

Just make sure you change your column names to whatever you are using in your sheet.

Paul Newcome

Try something like this...

=IF(AND([Due Date]@row <= TODAY(30), [% Complete]@row <= .5), 1)

Just make sure you change your column names to whatever you are using in your sheet.