Help! need help with my project health formula
My project health column is based on Expected Progress column. Works great with the exception where there there's no data (blank cell) the formula returns #INVALID OPERATION
I've tried adding a IF(OR(ISBLANK but haven't been able to get it correct. Would appreciate help/guidance!. Thank you
=IF([% Complete]@row = 1, "Blue", IF(OR(([Expected Progress]@row - [% Complete]@row) < 0.1, [% Complete]@row >= [Expected Progress]@row), "Green", IF(AND(([Expected Progress]@row - [% Complete]@row) >= 0.1, ([Expected Progress]@row - [% Complete]@row) <= 0.25), "Yellow", IF(([Expected Progress]@row - [% Complete]@row) > 0.25, "Red", ""))))
Answers
-
Hello @AClark200
It looks like you've asked the same question with this post, where I have replied with a clarifying question and proposed formula.
Help! Expected Progress Formula #INVALID OPERATION — Smartsheet Community
Let us know how you go.
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!