Departmental Ticketing System
I'm looking to merge several of our ticketing request forms into one form, such as maintenance requests, IT requests, and marketing requests. Based on the type of request, automation would be set to move those rows to another sheet for the admin to work out of rather than the original sheet with the request form. Has anyone been successful in doing so? Can you provide any reasons not to do this?
Answers
-
No real reason not to do it. In fact it's best practice. Except, I would ask why would you want to split the information back out to separate sheets.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Different people manage the different sheets. I figured it would be best not to merge the sheet into one since supervisors need to give access to specific people in their department, whereas someone in maintenance may not need access to the marketing requests.
-
That makes sense - a few options to consider:
- Use a report filtered by Current User (con to this approach is users still need access to underlying sheets)
- Use Dynamic View (an add-on).
Let me know if you need more info on option 2.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Hi @Dana Lopez
To add to Ramzi's excellent advice.
You could use the Form Logic to only show the relevant fields depending on the type of request.
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 help the Community by marking it as the accepted answer/helpful. 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.
-
what is the dynamic view add on?
-
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.
-
@Kristen Colangelo @Dana Lopez
Please feel free to send me an email ramzi@cedartreeconsulting.com if you would like to see Dynamic View in action and inquire on pricing and implementation.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
