At Risk Formula

Alexandra Sturchio

Hi Smartsheet team, I am having some issues coming up with an "At Risk" formula and would appreciate any help I can get.

I am trying to make the AT RISK flag appear if the "status" of my task is "Not Started" or "Delayed" within 30 days of the "End Date".

Any help you can give would be greatly appreciated!

MCorbin

Try this:

=IF(AND(TODAY() - Date@row <= 30, OR(STatus@row = "Delayed", STatus@row = "Not Started")), true, false)

Alexandra Sturchio

Thanks! Unfortunately, it did not work and is saying unparsable. Is there something I need to change for column settings?

Alexandra Sturchio

Does anyone know what can be wrong as this formula doesn't work?

Heather Duff

Is your end date column set as a date column?

Heather Duff

Oh! Try this:

=IF(AND(TODAY() - Date@row <= 30, OR(STatus@row = "Delayed", STatus@row = "Not Started")), 1, 0)

Alexandra Sturchio

That worked, thanks so much Heather!!