Should I use Join / collect or Multiple If in this situation?
Hello Experts,
I need some help with this formula, I am trying to auto populate the Category Cell based on the check box value. Right now my formula only works on the first Sports checkbox value return.
=IF(Sports@row = 1, "Sports", IF(Entertainment@row = 1, "Entertainment", IF(Community@row = 1, "Community")))
Should I change to using a join and collect? But I won't be able to reference the header name right?
Any response is greatly appreciated.
Thanks,
Answers
-
I would suggest a "helper row". For this example I will use row 1, but you can use whichever row works best for you.
In this helper row, you are going to need to enter the text you want pulled (header name). Then the formula used to pull would be:
=JOIN(COLLECT(Sports$1:Family$, Sports@row:Family@row, 1), CHAR(10))
If you wanted to avoid the helper row, you would "add" your IF statements together instead of nesting them.
=IF(Sports@row = 1, "Sports ") + IF(Family@row = 1, " Family ") + IF(........................
-
Thank you Paul! The helper row with the Join and Collect is a great solution and it worked!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!