Formula Roadblock
I have a hit roadblock, and I needed a little help or additional eyes. The formula should be something of ease, but not working or responding the way it should. Please see my screen shot below. Everything about this works except for when I hit 100%. It does not return my “6-Complete” Statement. When it hits 100% it remains in “1-In Progress”. I have tried reversing the 0 and 100 and still did not work. Let me know if you see anything that I might have overlooked. Thank you
Best Answer
-
You are very close. Percentages are treated as decimals: 1 = 100%, 0.5 = 50%, etc.
=IF([% Complete]@row <= 0, "5-Not Started", IF([% Complete]@row = 1, "6-Completed", "1-In Progress"))
Answers
-
You are very close. Percentages are treated as decimals: 1 = 100%, 0.5 = 50%, etc.
=IF([% Complete]@row <= 0, "5-Not Started", IF([% Complete]@row = 1, "6-Completed", "1-In Progress"))
-
Amazing.. It worked. Thank you very much
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!