nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sign in to vote on this idea

Time Column Property

sjalwan

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.

Find more posts tagged with

Sheets

Idea Submitted

Comments

AngB789

love this idea. Right now I just use regular text columns and formulas but a dedicated column for time would be huge.

pspanos

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.

VirginiaK

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.

How to set it up: Create a Text/Number column for manual entry, or a Dropdown column to limit choices to prevent typos (e.g., 8:00 AM, 8:30 AM).
Why use it: It ensures users input data consistently, and it works perfectly with Smartsheet's TIME Function. [1]

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]

How to set it up:
1. Create a column for hours (e.g., 1 through 24).
2. Create a column for minutes (e.g., 00, 15, 30, 45).
3. Combine them in a third Text/Number column using a formula like: =Hour@row + ":" + Minute@row. [1]
Why use it: It allows you to use mathematical formulas to calculate pay or task duration without confusing the sheet's text format.

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.

How to set it up: Add a column and set its Column Type to Created (Date) or Modified (Date).
Why use it: It automatically stamps the date and time a row changes. To isolate just the time in a separate cell, use the formula: =RIGHT([Created/Modified Column]@row, 8)

darkmatter

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