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.
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
