mallen101✭

@Andrée Starå Just to make it easier on me, would you Join the Status Column (which has the PO Sent) with the Company Column (Which keeps the Contacts) then Join all Contacts that have their Status set to PO Sent? Will this then populate a cell with those contacts?

Thanks Andrée, I'm fumbling my around it now :)

I assume you would have to apply that formula to the original sheet then simply link the cell it into the 2nd sheet yes?

Sorry I misread your comment, if I had to collect them and add them on the Drawing sheet then in 1 cell... But I could do that with Cell Linking, although I wouldn't know how to celllink with a filter...

他们在不同的行和want to filter them based on their status.

No, I want to reference contacts in another sheet with a specific status in the row to create an email list to send automations... I feel this is currently not achievable in Smartsheet however...

Thanks for you reply, yes this does work but I was hoping to alleviate the extra work of adding a column to add a column formula to simply hide it for this to work :) All good though, thanks again.

Is there anyway to reference a summary field for an automation? @Genevieve P. It doesn't seem to work for me :(