Employee Pulse Survey Template Set Formula Question

Hello

I downloaded the template set for the employee pulse survey when I customized it, the formula to score the questions got erased. Does anyone have the the formula for the helper columns to assign a number next to the survey result? For example neutral should show 3 in the locked column.


Thank you!



Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @HFletcher

    The formula from that template set for that column is as follows:

    =IF([Communication - 1]@row = "Disagree", 1, IF([Communication - 1]@row = "Neutral", 2, IF([Communication - 1]@row = "Agree", 3, IF([Communication - 1]@row = "Strongly Agree", 4))))


    You can turn this into a Column Formula if you want to prevent deletions in the future.

    Cheers!

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!