Similar to how there is a date column format, there should also be a time column format. Currently there isn't, so my organization uses a text type column, which leads to huge data quality problems. Some people enter military times, some don't, some include PM in their times, some use pm in their times, and with it being a text column there is no way to set up validations around that.
I completely agree with this!
We were looking at using SS for a problem tracking/ticketing solution for our helpdesk, where tickets are submitted by end users and then managed within the solution. But they need to be able to track how long in minutes the ticket is open and escalate based on length of time the ticket has been unresolved. And to be used in reports to ensure that the helpdesk team is meeting the SLA for turnaround times.
This is the one issue blocking us developing ticketing solutions within SS
Actually, a true date/timestamp column option would work. thanks
Hi,
I hope you're well and safe!
Please have a look at my post below with a method I developed.
More info:
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
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.