Ordering Date/Time for Appointment Tracking

wmarcus
wmarcus ✭✭
edited 09/28/23 in Smartsheet Basics

I am currently working on developing an appointment tracker. Users would add a date and time of an appointment associated with a name.

I am having trouble finding a way to include a time and would like this in the end to be integrated with a google calendar. Is this possible?

Columns:

Name | Date and Time 1 | Date and Time 2 |

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @wmarcus

    There currently isn't a way for the Calendar view of a Sheet to represent time, it can only show tasks on a date basis.

    That said, you could have a Text/Number column in your sheet to record the time to keep track of the appointments, separate from your date columns. Smartsheet doesn't have a "time" type of column but you can record it as text. Please feel free to add your vote and voice to this Product Idea thread: Please let Smartsheet work with time

    Cheers,

    Genevieve