Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

If Nesting formula with checkboxes

Topic Labels: Formulas
1041 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alma_Barlow
4 - Data Explorer
4 - Data Explorer

I have 2 check box fields and a cost field. If one checkbox is checked and the other is unchecked I want the amount in the estimated shipping cost field to go into the Unshipped Cost column(this is the formula for the Unshipped Column cost field)

I have
IF({We Ship}=1 and {Shipped}=0)={Est Ship Cost}

Thanks in advance.

2 Replies 2

Hi @Alma_Barlow - you can do this:

Screenshot 2021-03-10 at 18.16.13

IF(
  AND({We Ship}, NOT(Shipped)), 
  {Est Ship Cost}
)

Which translates to:

If We ship is true and Shipped is false, then return the Est Ship Cost

Note that there’s 3 other possible scenarios for the checkbox combos and with the above all of these will return null or empty, so you might want to expand the formula to return zero or other values for these cases

Thanks works perfect.