Need help with Harvey Balls and Formula
Hello!
I am trying to use the four status Harvey Ball for a training course. I want it to show empty until completing a 3rd exam, 1/4 after completing the third exam, half after completing a 6th exam, 3/4 after completing a 9th exam, and full when completing a field evaluation.
I have this so far... =IF([Section 3 Exam]@row < 0.8, "Empty", IF([Section 3 Exam]@row > 0.8, "Quarter", IF([Section 6 Exam]@row > 0.8, "Half"), IF([Section 9 Exam]@row > 0.8, "Three Quarter"), IF([Field Evaluations]@row > 0.8, "Whole"))))
Keep getting Unparseable. Can anyone help?
Answers
-
Looks like you have a parenthesis problem - there was an extra parenthesis after "half" and one after "three quarter," and you were missing one at the end. Try this:
=IF([Section 3 Exam]@row < 0.8, "Empty", IF([Section 3 Exam]@row > 0.8, "Quarter", IF([Section 6 Exam]@row > 0.8, "Half", IF([Section 9 Exam]@row > 0.8, "Three Quarter", IF([Field Evaluations]@row > 0.8, "Whole")))))
Let me know if it works.
Best,
Heather
-
Still get this...all the exams in this case are complete, but all show one-quarter:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!