Need help with Harvey Balls and Formula

Options

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

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Options

    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
    Options

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!