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
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives