On-call schedule communication

Lemans@1966

We have an On-call schedule in which Person A may be on call and ask persons B, C, D, and E to take over a shift.

The On-call column is a contact email list.

Persons B, C, D, and E will receive an Update Request to identify if they can cover that shift.

Persons B and C respond that they can cover the shift.

Person A will make the choose which one will cover and make that change. An alert notification is sent out to the person who is chosen.

The original requirement was to let all team members know that a schedule change has occurred.

Now if person B is covering the shift, they only want person C from the above example to receive a "thank you but this shift was covered" alert notification and no other communication to D and E.

Thank you.

Find more posts tagged with

Email Notifications

automation

Accepted answers

All comments

Antonie B

@Lemans@1966,

The best way to achieve this is by using the option "Send to Contacts in a cell" to capture the correct recipient dynamically.

There will need to be a larger process designed around this in Smartsheet, and also determining how many on call people you have as a back-up.

I would need to know how your sheet is set-up before guiding you on some tips to set this in place, but please feel free to reach out!

Lemans@1966

I have columns that we use for an Update Request: The Requestor checks a box of the name of the staff member who they want to potentially take the shift. They can check multiple boxes.

Each respondent then opens the Update Request to identify if he/she can cover the shift.

The Requestor then chooses from a drop-down menu who is covering the shift which alerts everyone of who has been selected and makes the change in the On-Call Contact column which is a contact email address.

It would have been easier if everyone gets a message of the schedule change but the principal wants to send to the ones who are not selected a message stating that they were not selected…adds an extra step. I think I have to create another column allowing multiple contacts to be selected in that column.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.