If Statement Help

ggross
ggross
edited 12/09/19 in Formulas and Functions

I have a column with 6 options and I am trying to create a statement in another column that says: 

=IF((Stage1) = "Opportunity", "d73ba1f2-91ba-435e-9480-a2ccf08b36aa", IF(Stage1) = "Contact", "0137cc9c-51b4-40fb-bf06-73174c348733")

I have 6 total stages but can't seem to get this to work.  Any advice?

Geneva

Tags:

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You are actually pretty close. You don't need to put Stage1 in parenthesis, and you need to use extra parenthesis on the end for each additional IF statement. I also suggest using @row instead of the actual row number.

     

    Try this:

     

    =IF(Stage@row = "Opportunity", "d73ba1f2-91ba-435e-9480-a2ccf08b36aa", IF(Stage@row = "Contact", "0137cc9c-51b4-40fb-bf06-73174c348733"))

     

    Keep going with that pattern, and you should have one ) at the end for every IF statement you use. In the example above there are 2 IF statements, so there are 2 ). If you have 6 IF statements, then you will have 6 ) at the end.

     

    =IF(....., ......., IF(....., ....., IF(....., ....., IF(....., ....., IF(....., ....., IF(....., .....))))))

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • That did the trick.  Thank you so much!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!