Form Time format input
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
Answers
-
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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
@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.
-
yes thank you
-
@Leakhena Oeun Are you able to provide more details? Exactly what are you wanting to accomplish?
-
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.
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives