Formula for a "Nested IF" formula for Status to change based on Percentage Complete number?
Hi there,
I'm looking for a way to automatically update the "status" cell based on the "% complete" number.
If % complete is:
0% or blank = "Not Started"
1-99% = "In Progress"
100% = "Complete"
Thanks in advance!
Best Answer
-
Hey @Marina Han
Oops. I confused which column was what. Change the references of Status@row to whatever your [% Complete] is called.
This formula will go in your Status column
=IF(OR([% Complete]@row=0, ISBLANK([% Complete]@row)), "Not Started", IF([% Complete]@row<1, "In Progress", "Complete"))
Make sure to change the name of the column to match yours.
Kelly
Answers
-
Hey @Marina Han
Try this
=IF(OR(Status@row=0, ISBLANK(Status@row)), "Not Started", IF(Status@row<1, "In Progress", "Complete"))
cheers,
Kelly
-
Hi @KDM ! Thanks for your response. I am getting a "Circular Reference" error with your suggested formula. Can you please assist?
-
Hey @Marina Han
Oops. I confused which column was what. Change the references of Status@row to whatever your [% Complete] is called.
This formula will go in your Status column
=IF(OR([% Complete]@row=0, ISBLANK([% Complete]@row)), "Not Started", IF([% Complete]@row<1, "In Progress", "Complete"))
Make sure to change the name of the column to match yours.
Kelly
-
That worked! Thanks very much, @KDM!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.4K Get Help
- 447 Global Discussions
- 144 Industry Talk
- 478 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 490 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!