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 am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
Having trouble with an INDEX/COLLECT/CONTAINS formula. I have two sheets, my source and my destination; the source sheet has a column I want to collect into the destination. -Tool ID, is in both sheets and the target of the INDEX/MATCH, the source sheet might have this listed 6 or 7 times -Purpose of Device, there are…
