Is there a way to create a Smartsheet based multi-tier Ticketing System

Which Smartsheet Plan do you have?

If you have Enterprise, I would recommend exploring using WorkApps combined with reports and more, or another solution could be the premium app, Dynamic View.

Another option.

I recently developed a (what I call) Dynamic View Light. It's quite advanced, but in short, it's using cross-sheet formulas and INDEX/MATCH and a specific structure and method, so it's only possible to show data that should be available.

Would any of those options work?

The simplest method would probably be an Update Request process.

Would that work/help?

All comments

Hi @Stuart Black

I hope you're well and safe!

Yes, it can be structured in a couple of different ways.

We could use cross-sheet formulas.
Or maybe copy/move row to move it through the process

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

What do you think?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Hi Andree,

Thank you for the speedy reply. Please find attached a crude flow chart that I have pulled together for you that I would like to structure the system around.

I am not sure if formulas will work, I may need to brush up on some of my formula skills to make it happen. I essentially need 30+ independent sheets to feed into just 1 Centralized sheet.

Regards

Stuart

Updated image to provide example Ticket contents:

Which Smartsheet Plan do you have?

If you have Enterprise, I would recommend exploring using WorkApps combined with reports and more, or another solution could be the premium app, Dynamic View.

Another option.

Would any of those options work?

@Andrée Starå

Thank you so much for pointing me in the direction of Workapps.

Found a robust Solution Via Workapps to create each Local Site System which feeds into the Centralized Global System via a mixture of Automations and Cross-Sheet formulas.

Via Workapps each Site is able to only view their own System and data.

Global Administrators are also only able to view a 'Ticket' when Local Admins escalate the entry to the Global team for resolution.

Now onto the next challenge, to figure if there are methods to communicate back and forth via the ticketing system with End Users. Without the need to provide end users any form of Viewing access to the Ticketing Systems. Andree, you don't happen to have the answer in your back pocket for this do you? :)

Regards

Stuart

Excellent!

Happy to help!

Regarding the next challenge.

Are the End Users Smartsheet Users?

@Andrée Starå

Unfortunately, not all will be. And due to the nature of the data and content I would like only those Administering the System to have access, to include view only.

The simplest method would probably be an Update Request process.

Would that work/help?

@Andrée Starå

Yes after looking into this, I believe the update request option provides the best solution for now.

Thank you for all the help @Andrée Starå

All the best

Stuart