How to flag AT Risk task

I have Planned FInish Date (Date field), and Actual Finish (Date field) and % Complete field, I want to flag the task if it's past due and incomplete.

currently I tried :=IF(OR([Plan Finish]@row - DATEONLY([Actual Finish]@row) < 0, [% Complete]@row < 0), 1)

but not working as intended.

Thanks

Find more posts tagged with

IT & Operations

Comments

Andrée Starå

Hi DJ,

Try this. (I didn't include the Actual Finish because it's not needed as I see it, let me know if I was mistaken)

=IF(AND([Plan Finish]@row < TODAY(); [%Complete]@row < 1); 1; 0)

The same version but with the below changes for your and others convenience.

=IF(AND([Plan Finish]@row < TODAY(), [%Complete]@row < 1), 1, 0)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Djay

Thanks Andree, i's working.

Regards

Andrée Starå

Great!

Happy to help!

Have a fantastic week!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Automation not working
I have a Smartsheet automation setup to reminder the planning to complete their sections. It is setup to remind weekly until completed box is checked. They received 2 reminders and then the reminders stopped. Any idea what could be wrong? I can't tell that anything has changed in the sheet. Thanks Freda
How to disable popups that obscure my formula?
I'm editing formulas in a Sheet Summary. However, I'm prevented from seeing the formula by an annoying "helpful" popup that obscures my view. I can't figure out how to get rid of the popup. Does anyone know?
Workflow Error: "Recipients: Edit workflow to fix recipients list"
I am trying to create a workflow and for some reason it gives me an error with the email I entered as the recipient for my Alert. It is an email that I know works, it is shared to the sheet, and the access to the sheet is unrestricted. I am perplexed at what the issue is. Anyone else get this and know what the issue is?