I'm thinking it might be possible to create a form with date and time options (in 30-minute increments). Maybe something like this is already available?
You could use a form to get someone's preferred Date and then separately their preferred time (as a dropdown list). For example, something like this:
Here's a free webinar on forms:
However the selection through a form would submit the data to the underlying sheet as a new row, and wouldn't block off that date/time for another user if that's what you're looking to do.
Another option may be to configure a Sheet to have all your date/time options as different squares, then have users fill in the Sheet (instead of the Form). Keep in mind that they could potentially over-write someone else's selection, depending on what Sharing permissions you give them:
Is this what you were looking to do? If not, it would be helpful to see a screen capture example of how you want the data to be gathered / displayed.
I achieved this with a sheet & form, report and a dashboard chart for the result. It looks better than using something external, but it’s not perfect as it requires a lot of manual input to set up the dates. Happy to share what I did.
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
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…
we are looking to migrate out of smartsheet and are needing to export all of our sheets out and store them in onedrive. what is the best way to preform this?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.