New User Question - how to reference Multi-Select dropdown column values in a formula
I am trying to develop a budget component for a project plan (using the SmartSheet portfolio management template).
In the project plan worksheet, a task can be assigned to multiple people with different cost rates. I have multi-select column called "Assigned To" and another column for "estimated task cost". How do I walk through the contents of a multi-select column to then look up their rate in another table. I have the lookup working when it is a single value just not sure how to parse the multi-select column.
Here is how I am looking up the staff rates in case there is a better way - still very much a SmartSheet beginner:
[Estimated Labor Hours]@row * VLOOKUP([Assigned To]@row, {Staff Tiers and Rates Range 3}, 5) - [Actual Labor Hours]@row * VLOOKUP([Assigned To]@row, {Staff Tiers and Rates Range 3}, 5)
Answers
-
Are you able to provide some screenshots for reference with sensitive/confidential data blocked?
You are most likely going to end up using a SUMIFS, but I can't be sure until I see your structure.
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!