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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!