I recently started using Smartsheet Forms. One of the data types that I am interested in collecting is that of time in "HH:MM" format. Smartsheet does a good job having a variety of field types but I wonder if it could be expanded to include time?
Sign in to see the current vote count, add your own vote, or leave a comment.
I also require this format. While I have been able to work around it in the past for internal use, I am currently, creating a sheet/report set that will export to a CSV file for the OSHA 301A upload. The CSV format must be in 24-hour time format AND include the colon : in the CSV field or we will receive an error (field length must be 5 characters). Having the validation built into the column builder, or as a validation option in the form builder (like phone number or email validation) would be a huge help. Option to validate as hh:mm AM/PM and for a 24-hour clock hh:mm would be great as we don't always need the 24-hour clock. Additionally, hh:mm:ss can come in handy when calculating response times for our emergency vehicles. Thank you for your consideration.
I agree this would be a huge help in multiple forms we use to gather information and records from our employees. Our HR team is relying heavily on Smartsheet forms, for example our remote/hybrid work agreements, and right now with the "work hours" field an open text field we are not getting the required info—responses range from "all day", "AM", "remote", etc.
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Hi, I am part of a very large organization where hundreds will have Admin access to hundreds of Workspaces in order for them to contribute and make full use of Smartsheet features. Currently All Smartsheet workspace Admins receive Workspace access email alerts. Which means hundreds of team members will effectively be…
It would be useful if users who clicked a Dynamic View link (that they were not previously added to) could "request access" to the Dynamic View, and provide a reason, so that the admin can easily grant that access. The use case for me would be to avoid having to pre-populate and then maintain a user group of viewers, but…
