Skip to main content

Calculation changes in formula dependent on single-select column?

  • March 31, 2021
  • 2 replies
  • 27 views
T

Hi everyone,

AirTable formula newbie here! I am hoping to change the calculations I have in my formulas dependent on which item was selected in my single-select column.

Under “Locum $,” the formula is currently:

({Orientation Day}*180)+({Paid Days Off}*180)+({Coverage Days}*550)

The 550 value only applies to the “rural” communities. When “remote” is selected under the Community column, I would like to change that value to 600. Is it possible to create a formula that would automatically calculate the values dependent on whether “rural” or “remote” is selected under the Community single-select?

Thank you!

2 replies

A
Forum|alt.badge.img+18
  • augmented
  • Inspiring
  • March 31, 2021

Hi Tina. Just replace the “550” with an IF statement.

({Orientation Day}*180)+({Paid Days Off}*180)+({Coverage Days}*IF({Status}=‘Rural’,550, 600))

I assumed you meant {Status} column since I don’t see a {Community} column, but if I’m wrong (and it happens a lot), then swap out {Status} for {Community}.

If you end up using more than two options for that {Coverage Days} multiplier, then the SWITCH statement will be your friend.

Be careful copy/pasting from here to your formula window. Quotes get changed. Good luck!

T
Justin_Barrett
T
  • Tina_Ly
  • Author
  • New Participant
  • March 31, 2021

Hi Tina. Just replace the “550” with an IF statement.

({Orientation Day}*180)+({Paid Days Off}*180)+({Coverage Days}*IF({Status}=‘Rural’,550, 600))

I assumed you meant {Status} column since I don’t see a {Community} column, but if I’m wrong (and it happens a lot), then swap out {Status} for {Community}.

If you end up using more than two options for that {Coverage Days} multiplier, then the SWITCH statement will be your friend.

Be careful copy/pasting from here to your formula window. Quotes get changed. Good luck!


Thank you so much for your helpful response (including the tip about the quotes)! You’re right, I did mean {Status}! It worked perfectly - thank you so much :).

Terms & ConditionsAccessibility statement