Updating date columns
I have a due date column that was manually put in shown below. Next to it is how often the task needs to be done. Is there any way to set up an automatic formula that will create a new due date after the current one has passed, or will I always have to go in and manually change the due date for each task after the one has been taken care of and that date has passed.
Thanks.
Comments
-
Hi Megan,
Have you explored using the new Automation / Recurring Workflow feature?
The due date can probably be automated with a Multi IF formula.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives