Employee Pulse Survey Template Set Formula Question

HFletcher

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!

Genevieve P.

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

Genevieve P.

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

HFletcher

Thank you!