Index/Match Question
I have a formula need that I hope you all can help with.
I have two sheets that have a unique identifier. What I'd like to have happen is when the identifiers match between the two sheets, then data in one columm in a sheet, populates into a column in a different sheet.
So when the MHID's match between the two sheets, we want the list of deliverables in the top sheet to populate in the bottom sheet. I'm struggling to get the equation to work.
Please help!
Best Answer
-
Be sure to change the references to match yours.
=Index({Description},Match(MHID@row,{MHID},0))
See how this works out for you.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
Be sure to change the references to match yours.
=Index({Description},Match(MHID@row,{MHID},0))
See how this works out for you.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
I just re read what it is your wanting. Sadly multi select items can not be done in a formula. You can how ever make it show text values. using HAS functionality. how ever this will be a REALLY long formula depending on how many Deliverables you have in your multi select dropdown.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Thank you! My thinking was backwards on the formula!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!