If Formula with Dropdown conditions

Shawn O'Banion
Shawn O'Banion ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to get an IF statement to check conditions of 3 dropdowns and based on those being true either add a specific value or do a calculation.  Below is what I am trying, but I am only getting it to populate N/A, no matter what the values entered are.  If the 3 that are entered below are true it should enter the value of $467.00.



=IF([Visit Type]1 = "Temp Staff Aug", IF([Site Name and Number]1 = "Amgen France", IF([Sell Price]1 = [Sell Price]1 = "Engineer Day Rate", "$467.00", "N/A")))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!