Skip to main content

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.

Hi @Alma_Barlow - you can do this:



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

Hi @Alma_Barlow - you can do this:



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.

Reply


Terms & Conditions