Replicate a Sheet but with information updating
We have a Project Tracker that has all the information needed in one place. I want to replicate that sheet but have it update the cells when the Project Tracker gets update. I linked the cells and that was fine but if we have a change order and our people add a row in the middle of the Project Tracker, the replicated sheet won't recognize that new row. I have tried the automation to copy a row but it still needs the cells linked to update the cells. Which is fine but it still won't recognize an added row in the middle of the sheet.
The automations I have tried are-
-Copy a row to a new sheet when a row is added or changed when a job number is entered
-I created a column in the Project Tracker the gets checked by an automation if a new row is added and then had the automation Copy row to a new sheet when the checkbox is checked.
Neither of these seem to recognize the row that is added in the middle of the sheet, even if the checkbox is checked.
This project tracker is updated multiple times a day so we can't be adding in these rows manually.
I should also add that I don't want to do a report as I want to add additional information (ie add a new column for the current month but I want to be able to reference the previous months column)
Answers
-
Could you add an auto number column to your tracker sheet so that each row has a unique number and then add a matching number column to your second sheet?
That would enable you to use a formula to return the data in the tracker sheet in the second sheet based on matching the number.
VLOOKUP will be the easiest to set up but will not enable you to move columns around.
INDEX MATCH is more flexible.
Have a look at:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!