=IFERROR(INDEX(COLLECT(

Options
lea.s6
lea.s6 ✭✭✭✭
edited 10/25/22 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!