Start and End times in Start and Finish Columns

Hi all,

Is there a way to enter start and finish dates and TIME into the Start and Finish columns? My Smartsheet configuration only accepts dates and I can't find a way to format the cell to show TIME, as well (e.g. 10/12/20201 02:20:15

We're trying to use Smartsheet to plan deployments, which can be multiple tasks over a few hours. We'd also like to view all of the tasks on a gantt chart, which should be possible if I can figure out how to enter Time into the Start and Finish.

Thanks in advance!

Mike

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Mike R.

Smartsheet does not currently have the functionality to include time into standard Date columns, such as Start and End dates. Please provide your feedback and identify your use-case to our Product team through this form, here!

If you're using a Project sheet and you want to identify that a task is scheduled for a few hours in a day, then you can use "h" in the Duration column to identify that the duration is only "2h" for example.

Although you won't be able to identify which hours in the day these are, it will show in the Gantt view as a shorter bar than a full day:

Screen Shot 2021-10-19 at 1.06.59 PM.png

See Project Sheet Columns: Start Date, End Date, Duration, % Complete and Predecessors for more information.

Cheers,

Genevieve

Mike R.

Thank you!

All comments

Genevieve P.

Hi @Mike R.

Although you won't be able to identify which hours in the day these are, it will show in the Gantt view as a shorter bar than a full day:

See Project Sheet Columns: Start Date, End Date, Duration, % Complete and Predecessors for more information.

Cheers,

Genevieve

Mike R.

Thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.