Changing the values of multiple columns

[srea541]

Hi

I'm trying to change values in multiple columns based on the value of another column.

Column Q1 holds either 1,2 or 3

Q1_1, Q1_2, Q1_3 are all blank to start.

I have tried multi-field formula:

if [Q1] = 1 then [Q1_1] = 1

elseif [Q1] = 2 then [Q1_2] = 1

elseif [Q1] = 3 then [Q1_3] = 1

else NULL()

...and it just returns zeros. Unfortunately there's quite a few of these so doing them in individual formula tools would take forever.

What would be the best way to do this?

Thanks!

[grazitti_sapna]

Hi @srea541, could you please provide the input and output required?

[srea541]

Hi @grazitti_sapna,

The table starts like this:

I am trying to achieve this output:

Thanks!

[grazitti_sapna · Accepted solution]

@srea541  Thanks for the quick response. Here is my solution to your problem.

I hope this helps!

Thanks!

[srea541]

Thank you for this @grazitti_sapna! That works as expected!

How would this work if i wanted to do it for multiple questions e.g. Question 3 as well?:

Q3 would follow the same logic as Q1 did. I will ultimately end up with about 10 questions needing this done to them!

Thanks!

[grazitti_sapna]

@srea541 , yes it would.

Thanks!

[srea541]

Thank you @grazitti_sapna, I have marked your reply as solution :)

[grazitti_sapna]

@srea541 Thank you so much. Much appreciated!