Collecting time range in form
I'm creating a form to collect the days and times that employees will be out of the office so that I can get the info onto a dashboard for the team to refer back to. Since Smartsheet doesn't have time fields for forms the best workaround I could find was using dropdown fields with half hour time segments and have one field for start time and another for end time.
Trying to set this up such that an employee who will be out for a week can choose the dates for their absence and someone who will need to leave early for an appointment will be able to report the hours that they'll be out. Then summarizing the info on a dashboard as a calendar and/or table format for the team to refer to.
Any tips on finagling this workaround in Smartsheet?
Any other known workarounds for this?
Answers
-
Hello @SW8335 , i would suggest that the people can simple type a text like 08:34 then you can use the Time formular to convert. We did build a vacation request solution int he past including approval workflows if thiws might be interesting contact me.
Kind regards
Meet me at Engage in Seattle !
Nico | LinkedIn
CEO | Lighthouse Consultings
🔴Certified Smartsheet Partner _______________________________________________
addvalue@lighthouseconsultings.com
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives