Automation based off auto-date-stamps not always working
Hi,
I'm having intermittent trouble with a move-row-to-another-sheet automation triggering off of a Record a Date automation AND a user selecting a drop down.
Process- A user creates a PO and enters data into the PO Number field. The Record a Date automation recognizes any input into this field and posts a date into the PO date stamp column. The user selects the Buyer Action Complete drop down and selects green once they are ready. The move-row-to-another-sheet automation does not always take action.
Does anyone have any clues on why the automation is not moving these rows after both conditions are being met? Screenshot below with 2 of 3 rows meeting the criteria:
Intermittently effective automation:
Thanks for any advice+input.
Answers
-
Is it possible they are entering the PO number and marking it green at the same time so that te date field is blank when it is marked as green? Have you checked cell history to see when it was marked green in comparison to when the date was recorded?
-
Thanks Paul. You might be on to something, we'll have to test a few manual processes with the users.
I was under the impression they were entering data, saving and refreshing (per internal training instructions), but that might not be case…
Screenshots of timestamps all occurring in the same minute:
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives