Help Summarizing Columns
Thanks for your help!
I am looking to summarize in one column all of the reasons why something is red. For instance in row 2, I would like "why red" to be "Financial, Resources" because both of those two have red selections.
Other than creating a helper column for each health status then joining them, is there a more efficient way to do this? TIA!
Answers
-
Hi @Lauren Y
I would use the MATCH function to find the first "Red" for the RGY range.😁
Then, using the match position, use the INDEX function to look up the "Health Type" range.
I used the first row in my example, but if you want to use the column formula, you must prepare another sheet with a number column and a Health Type column.
If you want to find out all the "Red" as the Reason, first concatenate with the JOIN function and with the SUBSTITUTE function, convert "Red" to "R," "Green" to "G" and "Yellow" to "Y."
The conversion will give you something like "GGRYGRY."
Then, with the FIND function, find the second position of "R."
(If you want the third position or Health Type, do the same.)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives