Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
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
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!