auto populate data from one sheet to another

Khari Shiver

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.

Khari Shiver

Thank you!

Jen Lange

@Khari Shiver , have you tried creating an automated workflow in the main sheet with triggers based on the columns mentioned above?

You can create a workflow that's triggered by certain responses (conditions) to copy a row from one sheet to another. This tutorial is quite helpful – https://help.smartsheet.com/learning-track/smartsheet-intermediate/automation.

I think that would satisfy your use case. Otherwise, you could probably also create a formula that cross-reference your main sheet in the subsequent sheets to pull in relevant data.

Let me know if the workflow looks like a good fit for you.

-Jen

Khari Shiver

Thank you!