Trigger notification/update request based on time elapsed since last comment or action on a row

We're using a ticketing system and trying to find a way to trigger automatic update requests when a ticket/row has been unacknowledged for more than 12 hours. Currently we're using the comments feature to post updates to the ticket across shift changes.

How can I set an alert to go out if there has been no comment on a row for a certain period of time?

I used the ticket template found here:

https://www.smartsheet.com/solutions/help-desk-ticket-tracker-and-form

Or is there a better way to do this?

Thanks!

Find more posts tagged with

Templates

Sheets

Reports

Comments and Conversations

Update Requests

Comments

Mike Wilday

Smartsheets doesn't handle time well. Just dates. Here is a forum post I found that discusses it. You should submit a product enhancement request.

Thanks,

Dajah

Thanks Mike. I didn't see a link to the forum post- can you post it here?

I'm wondering if there's just a better workaround for this entire process.

Mike Wilday

Hmmm. Its linked to the text. But you can find it in the Community under Quick Links as well.

https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409&_ga=2.152475440.861254775.1514928966-46550230.1463434639

Dajah

I think I'm confused- you mentioned a forum post about time tracking, but the link is to submit a product enhancement request. I was wondering about the forum post?

Thank you

Mike Wilday

Whoops! https://community.smartsheet.com/discussion/date-and-time-format There you go.

Sign in to join the conversation!

Quick Links

Trending discussions

Submitting forms for approval
Any help would be greatly appreciated! We have a 3-step process for travel approvals. I am able to get the forms to the correct people. I now have a request for the ability to add comments during the approval process. Staff submit request via Smartsheet form Automation forwards the form to the manager for approval Once…
Why would an automation for movement not carry over a cell value?
Hi everyone, I’m running into an issue with one of my sheets and was hoping to see if anyone else has experienced this. Here’s the setup: I have a sheet where, when I check a box, the row moves to a “Completed” sheet. In my Total column, I use a formula that sums a group of cells tied together via a parent/child…
Unable to edit smartsheet forms without constant reboot
Is anyone having trouble with smarthsheet over the past several days? Every time I go into a form to edit it, the cursor jumps fields after each character is typed. It is so frustrating. In some cases the cursor gets frozen in a field and jumps back and forth between two fields and freezes the whole system. I have yet to…