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?

Find more posts tagged with

Accepted answers

All comments

Heather Duff

Hi @Garry Leonard

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

Garry Leonard

Still get this...all the exams in this case are complete, but all show one-quarter:

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.