Performing the Same Formula on Multiple Fields
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sure, Multi-Field formula is exactly what you need.
Hope that helps!
![](/skins/images/D34B41DA407DC996E7BFF253AD24F7E2/responsive_peak/images/icon_anonymous_message.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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].
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Inactive User - this is exactly what I was looking for!!! Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
if [Fruit]="Apples" then 40 else [_CurrentField_] endif
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Oh, I see, I missed the point about usage of the [_CurrentField_]. Many thanks @apathetichell.
![](/skins/images/D34B41DA407DC996E7BFF253AD24F7E2/responsive_peak/images/icon_anonymous_message.png)