=IFERROR(INDEX(COLLECT(
Moderator Note: Translated from French to English via Google Translate
Hi there,
I want to use the =IFERROR(INDEX(COLLECT() function to combine multiple data from different columns into a single column.
So I adjusted this function according to my need:
=IFERROR(INDEX(COLLECT({Dys D1}; {Dys D1}; <>""; {Dys D2}; {Dys D2}; <>""); 1); "")
However, when I put only one range with a criterion, the latter works very well but when adding the 2nd criterion, nothing is displayed.
Is there another method for multiple ranges? Knowing that I have about twenty columns to group.
Thanks in advance,
Cordially
Answers
-
You are going to need to pull it together on a row by row basis on the source sheet. Then you can pull it over to the other sheet.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks for your ansmer.
The problem is that the data of the diferrents columns came from a formular. So, the number of line in each columns change every day.
I would need a formula that groups the data and that goes to the next line if the one before is different from empty.
Like it's explain in this forum : How to: Take data in a row and show it in a column in a dashboard. — Smartsheet Community
I don't know if it was solved
-
Are you able to provide a screenshot of your source data for reference?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hello,
Thanks for your answer.
I have the first sheet who the data come from a formular.
The second sheet : it's what I want to have :
And if another data came from the formular, I have to have the data after "TEST 21".
Thanks
-
Hi Paul,
Do you have a solution to solve my problem?
Thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!