How can I automate task creation?
I'd like to automate the assignment of tasks upon reaching 90 days of a due date. I've figured out how to create a cell with the trigger date, subtracting the default period from the due date, but I can't figure out how to automate the task creation in a different sheet.
Answers
-
Hi @CamSME
I hope you're well and safe!
You could copy the row to the other sheet with a Workflow.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
@Andrée Starå Thank you for the idea! In this case, I don't see it working. I have a database of dates, when I get within 1 year, or 6 months, or 90 days, depending, I want it to identify automatically and generate a task to perform the task associated with the pending deadline.
It's looking like the closest I can get is to automate a notification to a person to tell them to generate a new task. Maybe it could be solved with API Integration? But auto tasking is a feature I'm sure most companies with high volume would need.
-
Hi @CamSME
Notifying someone to either create the task or the process flow makes sense to me, without knowing too much more about your set-up.
@Andrée Starå's suggestion of copying a row would work well if you knew exactly what tasks would need to be done for each of the different instances/timings. You could have one sheet set up as a template with the different tasks, then when the person get's the alert they could select the appropriate tasks and copy them over to your active sheet. See: Copy and paste hierarchy
Please also feel free to submit a feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community, explaining your use-case and example. This will allow other users to vote on your enhancement idea!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!