=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

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

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.

lea.s6

https://community.smartsheet.com/discussion/comment/348561#Comment_348561

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

Paul Newcome

Are you able to provide a screenshot of your source data for reference?

lea.s6

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

lea.s6

https://community.smartsheet.com/discussion/comment/348610#Comment_348610

Hi Paul,

Do you have a solution to solve my problem?

Thank you

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.