Would it be possible to copy rows to another sheet on a specific day of the week
If I was to use an =today() in a column to grab the current date and then a condition using the IF(WEEKDAY(Date@Row) = 1, and make an automation for say, every Monday (1), could I copy a row (or rows) to another sheet when that day condition gets triggered? I will try this as I think it should work…..but I am fairly new so that leads to my….
Second Question: If I automate data row copy to another sheet every Monday will the data overwrite or add to the existing Monday sheet the next week? I want to capture updates to existing rows each week so overwriting with new data would be ideal.
Best Answer
-
You wouldn't need a formula at all. You can set it for every Monday directly in the trigger.
It will add new rows, but you can use a formula on the second sheet to flag the most recent row(s) and use a report or filter to display only those.
EDIT: Forgot to include screenshot of setting up the weekly on Mondays trigger…
Answers
-
You wouldn't need a formula at all. You can set it for every Monday directly in the trigger.
It will add new rows, but you can use a formula on the second sheet to flag the most recent row(s) and use a report or filter to display only those.
EDIT: Forgot to include screenshot of setting up the weekly on Mondays trigger…
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives