Form Time format input

Leakhena Oeun

Hi smartsheet community I would like to know how we create form for times format input. And if smartsheet not support this do we still has any other solution to fixed this

Thnak you

Mark Cronk

Hi @Leakhena Oeun ,

Unfortunately Smartsheet does not currently support time or time formats outside of the system generated Last Modified or Created columns. You can't format a form field to Time. The time has to be manually entered or you can use the Modified or Created system columns.

@Paul Newcome posted the ultimate guide to time calculations at: https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time#latest

Might be something in there to help you find a workaround until Smartsheet add more time functionality.

Help?

Mark

Paul Newcome

@Mark Cronk Thanks for yet another shout-out!

@Leakhena Oeun If you are unable to locate a solution or need help adapting a solution from the thread linked above, feel free to let me know.

Leakhena Oeun

yes thank you

Paul Newcome

@Leakhena Oeun Are you able to provide more details? Exactly what are you wanting to accomplish?

Heleen de Waal - de Vos

Hi all,

I'm also looking for a way to have hours/minutes entered on a form.

This is required to collect opening and closing hours for each day of the week in a sheet.

So actually I need 14 time fields in 1 form (in 24H format not AM or PM)

Is there a way to set that in columns, so the form does not show 14 "lines" but 2 columns per day to enter the opening / closing hours side by side and viewed in a glance.

Something like this (screenshot from Excel Userform)

Besides that it would be really helpful if dates could be entered as dd-mm-yyyy as this is the default setting in Europe instead of mm/dd/yyyy

Can you tell me if you think Smartsheet can meet these requirements?

Thank you for your time in advance.

Andrée Starå

Hi @Heleen de Waal - de Vos

Unfortunately, it's not possible at the moment to get the same structure with the fields beside each other, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Regarding the dates, It's possible.

This might help.

I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Heleen de Waal - de Vos

Hi @Andrée Starå ,

Thank you for your reply. I will submit such a Change Request for sure.

I'm a newbie at Smartsheet and don't understand exactly how I could create the 2 forms with conditional logic as you suggest. I've only seen a tutorial video with the basics of conditional logic (as you might have guessed I'm more familiar with VBA)

Can you show me an example or screenshot so I can get a better understanding?