=JOIN formula with two COLLECT statements


Hey Community,

I'm running into a roadblock with a formula that I thought was correct, but its coming up with the error #INVALID DATA TYPE.

Here is the formula I'm using in reference to the pictured cells attached:


Essentially, here's what I want:

IF the team name in the [TITLE2] column equals the team name in the [TITLE]@row cell

AND the date in the [DATE2] column equals the date in the [DATE]@row cell

COLLECT all values in the [TOPIC2] column that meet this above criteria and put all those values in the [TOPIC]@row cell

Thank you for any help!!

Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @Benjamin Brunnette

    See below formula. This will collect all TOPIC2 where TITLE2 matches TITLE@row and DATE2 matches DATE@row.


    The collect formula you can just keep on adding all the criteria that you want. No need for an AND statement.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!