Issue with Copy Rows + Record a Date Automation
I am trying to create a workflow where a row from Sheet A is copied to Sheet B and the "Transfer to Marketing Date" column records the date the "Transfer to Marketing" field is checked. However, I'm encountering an issue where the row is copied to Sheet B before the date is recorded in Sheet A, resulting in the date not being reflected in Sheet B. Appreciate any advice on how I can populate the date and ensure it's copied over to Sheet B? TIA!
Best Answer
-
Hi @KMeyer
The issue is due to the logical flow of the workflow where the copy happens first followed by the record a date. Since you can't have a follow up action to Record a date, you can create two separate workflows. 1st will be for recording the date when Transfer to Marketing is checked. The second workflow's trigger would be when a date When rows are changed with the Transfer to Marketing Date changes to Any Value, copy the row to Sheet B. This way, you will have the copy happen with the date.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers
-
Hi @KMeyer
The issue is due to the logical flow of the workflow where the copy happens first followed by the record a date. Since you can't have a follow up action to Record a date, you can create two separate workflows. 1st will be for recording the date when Transfer to Marketing is checked. The second workflow's trigger would be when a date When rows are changed with the Transfer to Marketing Date changes to Any Value, copy the row to Sheet B. This way, you will have the copy happen with the date.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
@AravindGP, I was anticipating this would be the case, but I was hoping the simple (or what I thought logical) approach would be possible. Thank you for the response!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives