Automate Risk Flag

smartpmsg

I would like to automate the risk flag if the date is on or after the Target Date. I am new to smartsheet. having trouble with this. thank you

Andrée Starå

Hi @smartpmsg

I hope you're well and safe!

Try something like this.

=IF([Target Date]@row <> "", IF([Target Date]@row <= TODAY(), 1))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

rdangelo

@Andrée Starå Re: your formula, I was able to use it in the Risk Flag column. However, in addition to triggering the flag when the due date is in the past, I also need the added condition to only trigger if the Task Status is In Progress or Not Started. How do I add that?