Record a Date Automation not working with Move sheet automation
I have a checkbox that triggers two separate automation.
- Box checked = Record date
- Box checked = Move row to another sheet.
The move row automation is working, but the record date is not. Any ideas?
Answers
-
@fusiasuede
I think that your move row automation is triggering before your record date automation.
Workflows that are triggered by the same event run in the order that they are saved. with the most recently saved running last. See this post:
I number all of my workflows from 1 to 100... WHen i make a change in one of my workflows i resave them all to make sure the dependencies stay the same. I usually do this by adding or removing a period from the name. For example: 1 change cell workflow; 2 add date workflow; 3 move row workflow - would become: 1. change cell workflow; 2. add date workflow; 3. move row workflow.
-
Hi @FusiaSuede
Another option is to change the Move workflow so that it runs at a specific time of day or once per hour and is conditional upon the box check and date is not blank (presuming date is blank until your automation updates it).
I also number my automations - it keeps them in order so they are easier to manage.
Hope this helps!
-
Ker9's solution is really the best practice. This allows for scalability and will save you headaches in the future.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!