Sign in to join the conversation:
Here is my formula. It is in a project plan:
=IF(TODAY() > [End date]1, [% Complete]1 < 100%, "At Risk", "On Time")
Hi Andy,
At first glance, it looks like the percent complete is wrong. It's written as 1 for 100%.
Try this.
=IF(TODAY() > [End date]1, [% Complete]1 < 1, "At Risk", "On Time")
Have a fantastic weekend!
Did it work?
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
It also looks like you might be wanting to make sure both of those stipulations apply...
Try this... IF(And(TODAY() > [End date]1, [% Complete]1 < 1),"At Risk", "On Time")
I had tried that earlier and it didn't so I just tried again. Now error is incomplete argument set
That worked! Thanks so much Mike. I tried the "and" earlier and it wasn't working. Then I read that you can list "if" conditions (and it's called nesting) so I tried going with that.
Thanks so much!!!
You're welcome! Glad I could be of help to you.
Happy to help!
I saw that Mike answered already, and it's solved now!
Let me know if I can help with anything else!
Andrée
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
I need to extract information from 2 different sheets based on the name of the member organisation and the join year (i.e. DD/MM/YYYY). The 2 sheets have the same column titles, but one is for 2024 and another one for 2025. Where organisation joined earlier than 2025, then it needs to fetch the data from the 2024 sheet,…
How do I set up the automation to move a row once the created date reaches 5 days?
