Formula - Multiple IF rules

Bruce Case
Bruce Case ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I have the following formula working fine!  In short, based on the value of the “Application/Product” value, I auto populate the value of a Contact column. 

=IF([Application/Product]1 = "Edits", "Jane Smith", IF([Application/Product]1 = "Scripts", "John Doe", IF([Application/Product]1 = "Matrix", "Billy Bob", IF([Application/Product]1 = "Glory", "Jim Bob"))))


I am having issues trying to add a secondary rule to the equation.

  • As an example, from the formula above, I now need to factor in the Workstream column as well; therefore, in English:
    • If Application/Product = “Edits” and Workstream = “GSC” then populate with Jane Smith
    • If Application/Product = “Edits” and Workstream = “APAC” then populate with Billy Bob
    • And so on with the rest of my products.





  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Based on Smartsheet's rules for using the AND operator your formula should look like this... 

    =IF(AND([Application/Product]1 = "Edits", [Workstream Column]1="GCS), "Jane Smith", IF(And([Application/Product]1 = "Edits", [Workstream Column]1="APAC"), "Billy Bob"))

    Note: You have to close your and statement parenthesis... ="GCS) <--- Closes the and statement but doesn't close the IF statement. Then close all of your IF statements at the end.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!