Need to create a formula that returns multiple values

I need a formula that will return the values in green based on the information in the table.
I am pretty new to using complex formulas and I have watched 100+ videos on Join Collect - If Contains and I just can't get it to work. Any help would be appreciated.
Answers
-
I’m not sure about how to do this via a formula but could be done pretty quickly with a script.
If you could share the sheet to me, I’ll give you an example?
-
Hi @Marv,
I hope you're well and safe!
Can you elaborate on what you want to collect, when and where?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå - I want to collect the information highlighted in green using a formula.
So if an item is critical I want the name of the item to list in the critical item column.
-
@Marv ,
I am guessing my comment got missed.
But this could definitely be solved in a few minutes if you're open to the script / API idea.
Ryan
-
@Ryan - I ended up figuring it out but thank you for your help. I did not mean to be rude I have been under the gun on an assignment.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!