Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Formula to Activate the Empty, Quarter, Half, Three Quarter, & Full harvey balls in a STATUS column

✭✭
edited 01/02/20 in Formulas and Functions
This discussion was created from comments split from: Formula to Change Harvey Ball Color Based off of a Word.

I'm struggling with this formula. I have a drop-down column called STAGE, where there are 17 stages listed. I'd like these options to activate the Empty, Quarter, Half, Three Quarter, and Full harvey balls in a STATUS column. For example, 5 of the options in the STAGE column are NEED INFO, BRIEF RECEIVED, PRODUCTION, APPROVAL, DELIVERED. Where do I put the brackets so that these words populate harvey balls in the STATUS column (Empty, Quarter, Half, Three Quarter, Full, respectively)?

Best Answer

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions