Skip to main content

Hello, I am new to Airtable and formulas. My current formula is this

IF({Full/Part Time}="Part-time", 0.5, IF({Full/Part Time}="Full-time", 1.0, 0))

I want to add a condition that if another field has two selected clients, the part time value of 0.5 will be doubled.

The Full/Part Time column is a single select field. The formula isn't coming up with any results. Any idea what I did wrong, or what's missing in my formula? Thank you!

 

Hi,
Please add more details
What does it mean ' if another field has two selected clients' ?
Is it number or link field? What if number of clients >2 ?  What if it has 2 clients and select is "Fill time", should it still be 1.0 ?
Actually, I would start from the second condition,
IF( _there_are_two clients ,  value_if_true , value_if_false )  and then included  first condition to the respective value.

You can also know that in Airtable you can use  IF( condition , value_when_true )  ,
the default for false is empty string or 0.
You can include condition in brackets in math expresiions  like   (1+ ( clients =2 )) * your_formula_result ,  it works as TRUE=1, FALSE=0, but that's the next level 🙂    For better readability use AND, OR
Also, to check multiple possible results, use SWITCH

SWITCH( {Full/Part Time} , 
"Part-time" , 0.5 , 
"Full Time" ,  1.0 )

Reply


Terms & Conditions