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
Solved! Go to Solution.
Sure, Multi-Field formula is exactly what you need.
Hope that helps!
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].
@Inactive User - this is exactly what I was looking for!!! Thank you.
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
if [Fruit]="Apples" then 40 else [_CurrentField_] endif
Oh, I see, I missed the point about usage of the [_CurrentField_]. Many thanks @apathetichell.