I'm working on the template "Employee Pulse Check" template and need help with this formula.

Options
AngBur
AngBur ✭✭
edited 12/21/23 in Formulas and Functions

I am working off of the "Employee Pulse Check" template but doing it for customers instead.

I am changing the formula from this:

=IF(ROUND(AVG([(Converted) Overall]:[(Converted) Overall])) = 0, "Strongly Disagree", IF(ROUND(AVG([(Converted) Overall]:[(Converted) Overall])) = 1, "Disagree", IF(ROUND(AVG([(Converted) Overall]:[(Converted) Overall])) = 2, "Neutral", IF(ROUND(AVG([(Converted) Overall]:[(Converted) Overall])) = 3, "Agree", IF(ROUND(AVG([(Converted) Overall]:[(Converted) Overall])) = 4, "Strongly Agree")))))

I am only going to do Disagree and Agree, so how do I change this formula to work? Also, I've changed their numbers to be 0 and 5.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!