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 noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
Dashboard widgets are currently mostly static. I can display counts and charts, but I cannot click into a specific part of a widget to drill into the underlying records. It would be a big usability improvement if widgets supported interactive drill-down. For example: Click a bar segment (or stacked segment) to open the…
