Calendar blocking conditions

08/30/21
Accepted

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    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)

    thinkspi.com

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    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)

    thinkspi.com

  • Thank you SO much Paul!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com

Sign In or Register to comment.