If Statement Help
I have a column with 6 options and I am trying to create a statement in another column that says:
=IF((Stage1) = "Opportunity", "d73ba1f291ba435e9480a2ccf08b36aa", IF(Stage1) = "Contact", "0137cc9c51b440fbbf0673174c348733")
I have 6 total stages but can't seem to get this to work. Any advice?
Geneva
Comments

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", "d73ba1f291ba435e9480a2ccf08b36aa", IF(Stage@row = "Contact", "0137cc9c51b440fbbf0673174c348733"))
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!

That did the trick. Thank you so much!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 303 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!