I need to result the column's name when using a JOIN(COLLECT) or INDEX(MATCH) formula
Previously, Row 1 of my smartsheet contained the column's name. This way, I could write a JOIN(COLLECT) formula to return the column's name if certain conditions were met throughout the sheet for that row. That worked until we applied column formulas to some of the rows. Now Row 1 can't be the column's name because of the column formula. I see one of two solutions.
How do you exclude Row 1 from a column formula?
How do you return the column name in a JOIN(COLLECT) formula? and an INDEX(MATCH) formula?
Help Article Resources
Check out the Formula Handbook template!