Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 06, 2020 11:13 AM
Can someone help my brain wrap around this type of formula?
I’m trying to get different amounts to populate based on what is selected in a different field. For example)
Field 1 is State
Trying to get Field 2 to calculate: if Field 1 is Missouri, then Field 2 should equal $2.00, OR If Field 1 is Illinois, then Field 2 should equal $1.00
Solved! Go to Solution.
Mar 06, 2020 11:43 AM
Hi @Leah_Huelsing,
How manny variables do you have in the State field?
I think a Switch formula would be better since you dont have a “Formula” that needs calculations.
So it would be SWITCH({State}, “Illinois”, 1, “Missouri”, 2)
Since in typing from my phone, the quotation marks are not correct, please change them in your formula to the correct ones)
Hope that helps.
Mar 06, 2020 11:43 AM
Hi @Leah_Huelsing,
How manny variables do you have in the State field?
I think a Switch formula would be better since you dont have a “Formula” that needs calculations.
So it would be SWITCH({State}, “Illinois”, 1, “Missouri”, 2)
Since in typing from my phone, the quotation marks are not correct, please change them in your formula to the correct ones)
Hope that helps.
Mar 06, 2020 12:10 PM
SWITCH worked, you’re amazing!
Mar 06, 2020 12:17 PM
My pleasure :slightly_smiling_face: glad it worked