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

✭✭
edited 12/21/23

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

• ✭✭✭✭✭✭
edited 12/21/23

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")
```

Jacob Stey

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!