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")))))
Answers
-
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!
-
Saw that I had Verbal agreement in place of Final Presentation 🤦♂️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives