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

AngBur

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.

SteyJ

https://community.smartsheet.com/discussion/114780/im-working-on-the-template-employee-pulse-check-template-and-need-help-with-this-formula

I'm assuming that IF the number is less than 2.5, it is disagree, and if it is greater than 2.5 you'd like it to say agree?

If this is the case, try this:

=IF(AVG([Converted - Prior Communication]:[Converted - Prior Communication]) >= 2.5, "Agree", "Disagree")