nesting If. Can't figure out why I get unparseable error
Here is my formula. It is in a project plan:
=IF(TODAY() > [End date]1, [% Complete]1 < 100%, "At Risk", "On Time")
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
=IF(TODAY() > [End date]1, [% Complete]1 < 1, "At Risk", "On Time")
-
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!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!