Because I'm in a hungry mood, this might do what you need:
=MAX(COLLECT([Row ID]:[Row ID], Fruit:Fruit, HAS(@cell, "Kiwi")))
Where fruit would be your multi-select column, then just replace Kiwi with whatever value you are looking to match.
Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
HAS() inside COLLECT()
Can you use HAS() inside a collect function (I think I need index(collect or max(collect in my scenario but unsure)?
I have a multiselect column. I'd like to collect all rows where a specific value appears within the multiselect column, then return the most recent row id (an auto generated number column in my sheet).
Answers
-
Because I'm in a hungry mood, this might do what you need:
=MAX(COLLECT([Row ID]:[Row ID], Fruit:Fruit, HAS(@cell, "Kiwi")))
Where fruit would be your multi-select column, then just replace Kiwi with whatever value you are looking to match.
-
Nesting this HAS function with "@cell" gave me the solution I have been looking for in a totally different scenario. So thankful for this response!!!💯
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!