Return a column value based on choice in Stage column (same sheet)
I know this is super simple, but I have spent hours with various formulas and can't get it to work. Any help would keep me from pulling the rest of my hair out. Thanks!
Based on the choice selected in the Stage2 column ( choices are: identify, delivery, closing by May31, closed past 6mos, or closing), I want to pull a specific column value.
If identify, return value from "Identify CR". Or, if Stage2 says 'delivery', return the value in the "deliv CR" column.
Thank you so much!
Best Answer
-
Hello @Stacy M
Here is a nested If statement formula for your application.
You might have to change the exact case of the words and column names so they match your data, but the basics are here:
=IF(Stage2@row = "Identify", [Identify CR]@row, IF(Stage2@row = "delivery", [Deliv CR]@row, IF(Stage2@row = "closing by May31", [<May31 CR]@row, IF(Stage2@row = "closed past 6mos", [CL6mos CR]@row, IF(Stage2@row = "closing", [Closing CR]@row,"")))))
Hope this helps!
Answers
-
Hello @Stacy M
Here is a nested If statement formula for your application.
You might have to change the exact case of the words and column names so they match your data, but the basics are here:
=IF(Stage2@row = "Identify", [Identify CR]@row, IF(Stage2@row = "delivery", [Deliv CR]@row, IF(Stage2@row = "closing by May31", [<May31 CR]@row, IF(Stage2@row = "closed past 6mos", [CL6mos CR]@row, IF(Stage2@row = "closing", [Closing CR]@row,"")))))
Hope this helps!
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!