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 see the current vote count, add your own vote, or leave a comment.
Similar to the other column properties, but restrict a column to time (whether 12 or 24 hour format) and be able to generate formula based on beginning and end times and other entries.
love this idea. Right now I just use regular text columns and formulas but a dedicated column for time would be huge.
If I am creating a form that asks submitters to enter a time, it would be helpful to have a dedicated Time field available. It would also be nice to have validation in this field that requires the input to be in 24 hour or AM/PM format.
This would be HUGE for my projects. Example: using Smartsheet to manage a preflight / prelaunch checklist where we need to track activities hour by hour (or even more granular than that). We're using a text/number field for now, but that can be stymied quickly when we rely on everyone to use the exact same format for time (as pspanos mentions above, being able to specify the time format would resolve that). This is troublesome if we're trying to sort checklist of events in order and we've got someone who entered 09:00 and another person who entered 9:00.
And that's assuming that fat fingering never happens. (looks down at floor, avoiding eye contact with everyone)
We want Smartsheet to automate the drudgery out of our work, and for the moment, we've still got to assign someone to nanny these sheets to make sure that everything stays clean. Even Excel (gasp!) handles this better! Please please please consider this.
PS: There are apparently ways to "work around" this, per this Google search. But I just KNOW that Smartsheet can figure out a much more elegant way to do this!
— — Google search results — —
1. The Dropdown Method (Best for Forms & Data Entry)If you need users to select exact times, use a standard dropdown or text/number column.
8:00 AM
8:30 AM
2. The Split Column Method (Best for Calculating Durations)If you need to calculate hours worked between two timestamps, split the time into multiple columns so Smartsheet can do the math. [1]
1
24
00
15
30
45
=Hour@row + ":" + Minute@row
3. System Column Method (Best for Timestamps)If you only need to track exactly when a row was created or last modified, you don't need user input.
=RIGHT([Created/Modified Column]@row, 8)
UPVOTE! This would add great value to my company too, where THOUSANDS of resource requests require time fields. We're working around this with Method 1 from @VirginiaK
Matt
If you’re looking for a way to handle time‑based calculations in Smartsheet without building complex formulas, there’s a small external tool that connects to Smartsheet and handles all of it automatically.
It’s called Working Time Engine, and it covers:
Start → End time differences
Total working hours
Break deductions
Shift validations
Clean, consistent time formatting
It’s especially helpful when formulas start getting messy or inconsistent with time values. It’s currently free to use.Here’s the link if you want to check it out: https://smartsyncapp.com/tools/working-time-engine
While there is no dedicated time type of column, there is a TIME function that can be used to greatly simplify most time based calculations.
https://help.smartsheet.com/function/time
.
Sign in to comment or add your vote.
