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
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.
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?
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.
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!
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
W: www.workbold.com | E:[email protected] | 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?
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
I need a formula that will count the day that a row is "Open" but stop counting the days once its "Closed" both instances need to display the count. Here is a formula I was trying to use. Thanks =IF([Date Closed]@row > 0, ([Date Closed]@row - [Date Opened]@row), TODAY() - [Date Opened]@row)
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.