Two Date fields with Automation
Hello,
I have a smartsheet that manages our department tasks. I currently have workflow automation for setting the next due date for the task but would like to also change the "Completed Date" to blank at the time that the due date is updated. Is this possible?
Best Answer
-
Hi @hgiffear
Yes, this is possible. I just tested it to be sure. In the Automation Menu, create a new one and choose "When rows are changed" chose "Due Date" changes to Any Value. Then choose "Clear cell value" in the Actions section and pick "Completed Date".
I hope that helps.
Matt
Answers
-
Hi @hgiffear
Yes, this is possible. I just tested it to be sure. In the Automation Menu, create a new one and choose "When rows are changed" chose "Due Date" changes to Any Value. Then choose "Clear cell value" in the Actions section and pick "Completed Date".
I hope that helps.
Matt
-
Perfect - I was trying to combine with the same automation for the change due date. This works perfectly! Thank you!
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