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.
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
