JOIN/COLLECT/IF statement

Ty Hickman
Ty Hickman ✭✭✭
edited 12/09/19 in Smartsheet Basics

Has anyone used a JOIN/COLLECT statement within an IF statement? 

Specifically, I want to join and collect responses across multiple rows where a column in the sheet has a specific value.

See the example, where I have data in a source data sheet that I'm trying to summarize on another sheet. 

Not even sure if JOIN/COLLECT is the right approach.  Looking forward to your input.

Thanks.

 

 

 

8-20-2019 1-28-41 PM.png

Comments