Replace latest row with data from another sheet
Hi,
I am trying to do the automation for replace latest row value from another sheet. So, I have a consolidation sheet and a reference sheet. Due do 2 of the projects submission are a week after the draft report review, I need to replace the latest row (not adding new row) with the most up to date data from the reference sheet automatically, is there a way to do it? The move and copy rows automation will only add into new row of your sheet destination.
The other scenario is to move the latest row in the consolidate sheet to new reference sheet and I make another 'copy rows' automation which is triggered by date from original reference sheet.
Thanks,
titania
Answers
-
Hi
You could use a function to collect the latest value from a sheet, but there would need to be a unique identifier on both sheets to match the rows. (it is also useful for the sheet that contains multiple entries, where you are taking the latest value from) has a couple of helper columns to create row numbers.
Feel free to reach out, if you'd like more help with this. My email address is in my profile.
Kind regards
Debbie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!