Join/Collect with 3 criteria


Hi everyone,

I am trying to use a Join(Collect formula to find 3 criteria. It looks like I can only have 2 criteria, but before I gave up, I wanted to see if I am missing something. Or does anyone have another way to evaluate 3 criteria? Thank you!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    It looks like you have some data type inconsistencies. Some are left justified and some are right justified. This means some are numbers and some are text (leading zeros create a text string).

    Insert a helper column in both sheets that have this column formula:

    =[Report Time]@row + ""

    Then use these helepr columns in your formula in place of directly referencing the time columns.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!