If Statement Help

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?




  • 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(....., .....))))))

  • ggross

    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!