Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hello All,
we are setting up a ticketing system to manage a medium (but growing number) of instruments. Unfortenately not all service requests can be handled in one visit. How can the "actions taken" column be updated lets say from zero to several times. In the best case each update corresponds to a service visit date. Any ideas or similar problems with totally different solutions?
Thanks in Advance
Hi,
Would it work if you used hierarchy with parent and children rows?
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi Andrée,
I like the idea. Could you show me how to setup the form to generate a parent and a child row?
Thanks a lot
Problems you may run into with a using the hierarchy(for a ticketing system that refers multiple times to the same thing):
(There's more, but those are the main ones)
That said, if Andrée responds with more details, that may be the solution (I am not opposed to it, just wasn't my first design thought)
I've tried to setup ticketing systems in Smartsheet and always need to resort to some outside tool to complement the solution.
Craig
Hi Craig,
thanks for your input!
I am already struggling with your first pain ponit
Therefore I am open for ideas that might help us to have a complete solution!
I don't often leap to this suggestion right away, but sometimes ...
This particular use case is so fraught with customer requirements that there is no one-size fits all answer.
I would suggest reaching out to Andrée or my colleague Richard at Smarter Business Processes (www.smarterbusinessprocesses.com)
Both offer 1 hour free consults and either can likely get you going after hearing more of the requirements and your current processes.
(yes, I suck as a businessman).
Personally, I struggle with reaching out to SME's myself. I have paid several and gotten nothing of value and then spent two weeks on a task that if someone would just comprehend my question, the task would have taken 15 minutes (true story andr recent)
Thanks for the invite, Craig!
I have the consider this,and align with the team.
Unfortunately, like Craig said it's not possible to do it automatically.
I have a few follow up questions.
Andrée
A very basic thought process would be to simply use the row comments instead of a separate "Actions Taken" column. The row comments would track who logged it along with the date and time stamp of each one. It wouldn't be as plainly visible as having an actual column, but it seems like it would serve the purpose. Either that or looking at the cell history would serve the same purpose.
With the row comments, you can use the option to print only the selected row and add comments. That would give you a hard copy of the life of the ticket and all actions that were taken. I see they have also added the @ feature to the comments to alert someone to your new comment.
we will end up with around 30 instruments in the next 3 years.
I hope the ticket number will be low But a realistic guestimate right now would be around 20-25 per month.
Currently we are working on two prototypes. I will make them nice and shiny and share some pics.
Best regards,
McMinski
I see the idea of this, but I think I this way generating a report/dashboard would be much harder.
Seems I have to dig deeper into the possibilities of the comment column. Something to consider! Thanks a lot
You're absolutely right. It would make reports much more difficult to pull using the row comments.
Feel free to share them even if they're a work in progress. I'll see if I have any tips & tricks.
Attached is a screenshot of a current grid for a ticket system.
Connected with this grid are 1 form, to enter a service ticket.
A request to update to select from a list of availabe technicians. When one is selected, the submitter recieves a notification and the technician a request to update. When the technician uses the form to set the status resolved the submitter gets an approval request. One additional information from the update form is the parts used information which the automatically reduces the number of available spares in the table "Parts List". If in the "Parts List" the number for each spare drops below a certain number the admin is notified.
Currently i am working on a way to insert more than one spare part in the update form and a printable version of the service report for the technician after it was approved by the submitter
The timestamp is now done automatically.
Dynamic lookup of the available parts is now possible, now I am looking for a way to put in multiple parts in the update form.
Does anybody know a good way to realize this?
Update form. As in you are sending out an update request? When I want to join together a list of options into a single cell from a form, I generally create a checkbox column for each option using the option as the column header. I then retype the column headers into row 1. I then use a JOIN(COLLECT( function to pull all of the selected options together while leaving out the unselected. In the example below, the number on the left is the row number. The bold portions are the column headers.
Part 1 Part 2 Part 3 Part 4 Parts Selected
1 Part 1 Part 2 Part 3 Part 4
2 Y Y Y Part 1, Part 2, Part 4
3 Y Part 2
.............................
The formula to put in the Parts Selected column would be
=JOIN(COLLECT([Part 1]$1:[Part 4]$1, [Part 1]@row:[Part 4]@row, @cell = 1), ", ")
Assuming the Y in the example above denotes a checked box.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
When i try to send or print the timeline view instead of showing the progression bars like they do on the screen it only send the data entered and not a graph type view to print. Is there a way to do this. I am using a mac platform if that helps.
