Smartsheet Product Feedback & Ideas

Smartsheet Product Feedback & Ideas

Help shape the future of Smartsheet! Share your feature wishlist and improvement requests here.

Sign in to submit new ideas and vote
Get Started

Please let Smartsheet work with time

124

Comments

  • ✭✭✭✭✭
    edited 01/31/25

    Actually, a true date/timestamp column option would work. thanks

  • Community Champion
    edited 01/31/25

    Hi,

    I hope you're well and safe!

    Please have a look at my post below with a method I developed.

    More info: 

    Lock or Store Date/Value Solution without using Zapier

    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.

  • ✭✭✭✭✭

    Another use case is for support ticket tracking. We track how long a ticket is open along with its priority to determine when to escalate the ticket. We have SLAs ( service level agreements) in place for how quickly a ticket needs to be responded to as well as different levels of escalations and communication times ( it would be great to automate these).

    Of course, we would want to do reporting on durations in hours, minutes, seconds (maybe not).

    We are looking to replace our current ticketing system, but cannot even consider using SS without have the options to create timestamp columns.

    Thanks

  • Community Champion

    Hi,

    I hope you're well and safe!

    Please have a look at my post below with a method I developed.

    More info: 

    Lock or Store Date/Value Solution without using Zapier



    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic day!

    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.

  • ✭✭✭✭✭✭

    Would be great to have standardization across data!

  • Community Champion

    @Cathy Salscheider Here's a method I developed for timestamping specific actions within a sheet. It doesn't provide for a ton of scale, but it does work. Once captured, you can use an INDEX/MATCH or similar to bring the timestamp back over to your original sheet if needed.

    Date/Time Stamp Option

  • ✭✭✭✭✭

    @Paul Newcome Thanks Paul. Creative idea - this could work. Thanks for the idea.

  • Community Champion

    It would be fantastic if Smartsheet could account for the time it took to complete each task.

    Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant

    Core App, Project Management and System Administrator Certified🏅

    E: leroy.noriega@yahoo.com | Linkedin Profile

  • ✭✭✭
    edited 01/31/25

    Hi,

    My VP would like for people to log the time they received the email from the customer. Can you please add this as a request for development? Thank you in advance.

  • edited 01/31/25

    Yes, this is something I also need for data reporting and compliance. "Time" and "Date & Time" column types would be a huge help.

  • ✭✭✭✭✭
    edited 01/31/25

    Hi,

    Would it be possible to have "Time" column type option as one of the column properties. And if possible to have the ability to chose between Standard Time or/and Military time.

    We are currently have formulae to pull Time (Standard) from the Create column and then converting that time to Military Time. The downside about this is, we have a couple of users across regions and what happens is that time keeps updating based on the time difference of the last person that saved the sheet.

    In addition to this, could an automation for record time also be created. That should be different from the record date automation.

    Thank you

    Best regards,

    Jacob A. PMP, AgileXP, CSM

    Please kindly upvote if my contributions have provided you some value or answer. Thank you

  • edited 01/31/25

    This would be extremely helpful. I have a Conference Room Request sheet set up and there is no function for a column to allow the user to select what the start/end times are for their request. End users put in all kinds of different information (8am, 2:15pm, 2…)

  • edited 01/31/25

    I would like to have the date and start time in 1 column. This is for a good display in the giant view. If there is now a one-hour job, the display is from the start of the day

  • ✭✭✭
    edited 01/31/25

    I use smartsheet to capture input from a wide audience. It'd be great if i can fix a standard format for a time column (e.g. 2:00 am or 02:00) to ensure accurate information.

  • ✭✭
    edited 12/30/24

    Currently after speaking to support there is no way to validate a 24 or 12 hour time format. Attempting to build a schedule based upon form submissions and for them to auto sort based upon date AND time, but currently without manually sorting the column this is not possible. Was suggested to make this request of the Dev team and see if this can be implemented.

Trending Ideas