auto populate data from one sheet to another

Hello everyone,

I'm new to Smartsheet but do have a fairly robust knowledge of Excel. I've created a sheet with job codes, associated titles, and pay rates. A row has a venue name, a job title, a department, and a pay rate. I would like to create secondary sheets where if a job title/department/pay rate is added to the main sheet for a specific venue, it would automatically be added to one of the secondary sheets.

Example: The following is added to the main sheet

Based on the venue name, the first line of data would automatically be added to a secondary sheet for Theater A and the second line would be added to a different secondary sheet for Theater B. I am hoping this can be accomplished by the use of formulas but am not sure.

Thank you in advance.


Best Answer