Harvey Ball Formula Question

Where di I make a mistake? Current formula is below and not correctly converting Stage Progress to a three quarter Harvey ball when Last Activity Type is Final Presentation.

=IF([Last Activity Type]@row = ISBLANK([Last Activity Type]@row), "Empty", IF([Last Activity Type]@row = "Initial Presentation", "Quarter", IF([Last Activity Type]@row = "Survey", "Half", IF([Last Activity Type]@row = "Verbal Agreement", "Three Quarter", IF([Last Activity Type]@row = "Qualified Win", "Full")))))

Find more posts tagged with

Accepted answers

All comments

Leah ISAAC

Hi Adam:

It looks like the conditions for "Final Presentation" are not included in your original formula. Try using something like this:

=IF([Last Activity Type]@row = ISBLANK([Last Activity Type]@row), "Empty", IF([Last Activity Type]@row = "Initial Presentation", "Quarter", IF([Last Activity Type]@row = "Survey", "Half", IF(OR([Last Activity Type]@row = "Verbal Agreement", [Last Activity Type]@row = "Final Presentation"), "Three Quarter", IF([Last Activity Type]@row = "Qualified Win", "Full")))))

Hope this helps!

Adam Kinney

Saw that I had Verbal agreement in place of Final Presentation 🤦‍♂️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.