Calendar blocking conditions
Hi! Is there a way to create date block conditions so that in calendar view, a meeting is blocked for that date and also the day after?
For example, if someone requests a meeting for September 15 in a form I've created in Smartsheet, I would like the calendar to automatically block off September 15 and September 16. And in the case that the meeting date falls on a Friday, the Monday is blocked on the calendar too.
Is the two scenarios above possible?
Thanks!
Best Answer
-
You would want to have start and end date columns established. the start date column would be the day of the actual meeting, and then the end date column would have a column formula along the lines of
=WORKDAY([Meeting Date Column]@row, 1)
Answers
-
You would want to have start and end date columns established. the start date column would be the day of the actual meeting, and then the end date column would have a column formula along the lines of
=WORKDAY([Meeting Date Column]@row, 1)
-
Thank you SO much Paul!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives