Automation Workflow
Hi, Can someone help me create an automation workflow that will automatically move data from the current sheet to another when it's more than 12months?
Thank you in advance.
Best Answer
-
I build this automation for a claims tracking sheet. It's based on the creation date of the claim, which is setup as a Auto-Number/System column for Created (Date). I think a similar automation would work for you, just change the Condition to 365 days. If you specifically need it by months, you might need to build a helper column to calculate the number of months.
Answers
-
I build this automation for a claims tracking sheet. It's based on the creation date of the claim, which is setup as a Auto-Number/System column for Created (Date). I think a similar automation would work for you, just change the Condition to 365 days. If you specifically need it by months, you might need to build a helper column to calculate the number of months.
-
Thank you, Jason.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 149 Just for fun
- 69 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!