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.
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
Be able to print and/or export Workflow Automations in PDF and/or export to Visio. this would be used for document control and troubleshooting aid
It would be beneficial to be able to leverage Smartsheet Automations to make REST API calls. This has many potential use cases, but one I could see is adding users to Smartsheet groups when the are added to a 'roster sheet' in Smartsheet. It would allow us to use the full power of Smartsheet's API within easy to use…
