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
-
Thank you!
Answers
-
@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
-
Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives