Return a list of cell values if one criteria is met


I would like to return a list of Project IDs (four digits) that meet the same criteria , so I went for :

=JOIN(COLLECT({Project Summary MASTER Range Project}, {Project Summary MASTER Range Time}, "Yellow"))

Unfortunately, it comes back as an 8/16/20 etc digit long without any separation - is there either

1) an other function I could use

2) An additional function to separate the joined data in another cell?

Thank you

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!