Help

How to combine "IF" and "SWITCH" formulas

Topic Labels: Formulas
496 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Erez_Malka
4 - Data Explorer
4 - Data Explorer

Is it possible to combine “IF” and “SWITCH” formulas into one?
i am trying this formula and i am keep getting an error:
IF ({Send to FBA},SWITCH({Product Type}, ‘Individual’, {Arrive to Prep Center}*1.5, ‘Return’,{Arrive to Prep Center}*2.5)

The “Send to FBA” is a checkbox field
When i do this formula alone it works great:
SWITCH({Product Type}, ‘Individual’, {Arrive to Prep Center}1.5, ‘Return’,{Arrive to Prep Center}2.5)

But i want this formula to work only if “Send to FBA” is checkbox!

1 Reply 1
Raminder_Singh
7 - App Architect
7 - App Architect

Looks like you are missing the closing parenthesis. Just add a ) to your formula and it should work: IF ({Send to FBA},SWITCH({Product Type}, 'Individual', {Arrive to Prep Center}*1.5, 'Return',{Arrive to Prep Center}*2.5))