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", "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
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", "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(....., .....))))))
-
That did the trick. Thank you so much!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!