Performing the Same Formula on Multiple Fields

[kheuer]

Hi,

I am performing the same exact If Then statement for each of the fields below. Is there one tool that allows me to update each field based on the same statement?

Thanks in advance!

---Kristina

[JohnJPS]

Sure, Multi-Field formula is exactly what you need.

Hope that helps!

[BPurcell2 · Accepted solution]

I'm not sure of your use case, but the multi field formula is designed to run the same formula against multiple fields.

Make sure to pay attention to the configuration.  It defaults to creating a new field, leaving the existing one intact.  If your formula is using the value in the fields (in your case Jan, Feb, etc) you would use [_CurrentField_], otherwise you could run it against another field like [Yes/No].

[kheuer]

@BPurcell2 - this is exactly what I was looking for!!! Thank you.

[inguli]

Hi,

I'm trying to achieve a similar thing but I need for else to stay as it is. IIF([Fruit]="Apples", ToNumber("40"), ????????)

What is the best way to achieve this?

Many thanks

[apathetichell]

if [Fruit]="Apples" then 40 else [_CurrentField_] endif

[inguli]

Oh, I see, I missed the point about usage of the [_CurrentField_]. Many thanks @apathetichell.