LOOKUP, IF(OR, or ?. Can this be done in Smartsheet?
I need some guidance please. I have LOOKUP formulas working in other sheets, but I need this operation to work sort of backwards.
In NWM1.png below, I show the columns I'm working with, this sheet is populated via a Smartsheet form, per our usual method.
"Initiative" needs to be populated relative to a value that will be form entered into one of the 5 columns to the right. Each of those columns is a drop-down style, selected in the form. Each of those 5 columns has 1 - 6 options.
NWM2.png shows column CD1 with all of the options available in the 5 columns to the right of "Initiative" column. Column CD2 shows the 5 options that should populate "Initiative" based on the value selected in one of the 5 columns.
I.e., If "Planning" is selected under ProjPrep-Deliverable, then "initiative" should be populated with "Project Preparation".
"AgenRec-Deliverables" can have 1 of 4 options selected, but should populate "Initiative" with "Agenda Recommendations" no matter which of the 4 selections is selected in the form.
Is this possible?
Thanks.
Comments
-
Can you provide screenshot with dummy data of how you want this to look? I think I have an idea of what you are trying to do, but I am not 100% certain I am following.
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!