Convert Data Value into Nulls

[mzsweetumz]

Hello, I am trying to turn all the rows with "Other (Comment)" into NULL values.

The value has to be exactly  "Other (Comment)" -- any other rows with a reason after that does not count.

What formula do I enter to get that?

[binuacs · Accepted solution]

@mzsweetumz One way of doing this with the Multi-Field formula

[gautiergodard · Accepted solution]

@mzsweetumz solution attached! 

Hope this helps!

[mzsweetumz]

Thank you @gautiergodard  and @binuacs ! It worked :)

[ShankerV]

Hi @mzsweetumz 

You can use the Multi-Field formula to reach your solution.