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'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
I have a sheet where I query 14 other sheets to collect all sorts of data (unique values from sheet into a column) and in another column I use an Index distinct collect to get all the unique value from those 14 columns, this is the 'Index' column. At some point a user will want to generate a certificate associted with the…
