Automation - Changing data on feeder sheet will update recipient sheet too?
Hi there,
I was trying out the automation function to link important dates from several project plans to one central location that will act as a calendar.
Automation is: If "Add to calendar" = checked, copy row to calendar sheet.
The premise works well, but in cases where the date changes on the primary sheet, this does not update the row that was fed to the calendar initially.
The workaround is to ask that when a row is updated that has been shared to the calendar, that the user saves the date, then unchecks and checks the "Add to calendar" box, and saves again. This adds a new row to the calendar sheet (again, not a massive issue just takes some managing), but if the person is using predecessors or dependencies, they may miss the date changing and forget to do the workaround.
Is there something i am missing on this, that maybe can update the rows downstream when updated on the feeder sheet?
Thanks in advance,
James
Best Answer
-
Hi @James Adderley,
When a row is copied (or moved) to another sheet, any changes made to the original row will not reflect in the copied row unless the cells have been linked.
More information on cell linking can be found here: https://help.smartsheet.com/articles/861579-cell-linking
Since you're looking to show rows from multiple sheets in Calendar View, I would recommend creating a Report and then viewing the Report in Calendar View. When you're building your report, you could use the "add to calendar" column as the criteria that pulls rows into the report. For example, the "What" criteria in the Report Builder could be "add to calendar is checked".
If needed, more information on building Reports can be found here: https://help.smartsheet.com/articles/522214-creating-reports
Answers
-
Hi @James Adderley,
When a row is copied (or moved) to another sheet, any changes made to the original row will not reflect in the copied row unless the cells have been linked.
More information on cell linking can be found here: https://help.smartsheet.com/articles/861579-cell-linking
Since you're looking to show rows from multiple sheets in Calendar View, I would recommend creating a Report and then viewing the Report in Calendar View. When you're building your report, you could use the "add to calendar" column as the criteria that pulls rows into the report. For example, the "What" criteria in the Report Builder could be "add to calendar is checked".
If needed, more information on building Reports can be found here: https://help.smartsheet.com/articles/522214-creating-reports
-
I agree with @Alejandra. It sounds like a report would be a great solution for this.
-
Thanks @Alejandra and @Paul Newcome, will try running via a report, rather than automation.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives