Opening a template by selecting a check box or status field
Hello all,
I am very new to Smartsheet so please excuse the question. I know how to do the following in excel but haven't found a way to do it in Smartsheet.
I have a list of courses that belong to certain programs. I would like the program chairs to select the courses they would like for my team to work on by selecting a checkbox field for the course. I have already created a project management tracker sheet and have made it into a template. Once the program chair selects the course they would like my team to work on I would like to assign it to someone and then automatically launch the templated project tracker. Additionally, I would love it if the course ID, course Name, Instructor Name and the resource name from my team would flow over to the project tracker from the sheet that the program chair selects the course.
Any thoughts on the following:
1. How to add a check box or status field that when selected automatically launches the course project tracker template?
2. How to launch a template to include information contained in other sheets? I track nearly 60 projects at a time and don't want to manually update all 60 sheets with the Course Information, Instructor Information and Resource Information if it is already found in the other smartsheet.
Any help would be greatly appreciated.
Comments
-
Hi Matt,
This is quite complex!
I'd happily work with you and help you with setting up a solution.
There are a few different ways to do this, and I need some more information to see what would work best for your particular situation.
If you'd like we can book a time for a free discovery call. How does that sound?
Please e-mail me at andree@getdone.se and well take it from there.
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant / Get Done
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.
-
Hi Matt,
How did it go? Did you manage to get something set up?
Best,
Andrée Starå - Workflow Consultant @ Get Done
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
- 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
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives