Dec 14 2022 04:39 AM
Hi, I'm trying to create a formula for Form Assembly connecting with Salesforce. I know nothing to do with Excel but thought the logic might apply.
We have one field which is a picklist of 3 different prices.
Each price creates a record.
What would the if formula be for it?
@if PICKLIST is PRICE1 do this, PRICE 2 do this, PRICE 3 do this.
Dec 14 2022 05:11 AM
=IF(A1=5,"do this",IF(A1=10,"do that",IF(A1=15,"do else","")))
If the cell with the picklist is A1 you can try this formula. In the formula the prices are 5, 10 or 15. You can replace "do this/that/else" with a calculation for example.