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!
Best 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
-
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 -
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!