> For the complete documentation index, see [llms.txt](https://guide.rooster.gov.sg/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://guide.rooster.gov.sg/features/monthly-rosters/assigning-to-on-call-and-team-rosters.md). # Assigning to On-call and Team Rosters Add assignments to your roster directly in Rooster, or using an Excel file. {% hint style="info" %} ## Unable to find a staff member? You can [add their contact](/features/directory-contacts.md#how-do-i-add-a-new-contact) on the directory page before assigning them to a roster. {% endhint %} ## Adding assignments to your rosters ### **Step 1: Go to your respective Roster** On the roster page, click '**Edit Assignment**'. ### **Step 2: Select a way to assign** Choose one of the methods to add your assignments on your roster.

Add individual assignments

1. Hover over the cell to which you would like to add your assignee(s), and click '**Add Assignment**'.

2. Select role, team (for Team Rosters only), staff, and single/multiple date selector on the pop-up.

* Dropdown options under '**Role**' should be the same as column headers. * You can search for staff by their display name, MCR number, designation, or by scrolling through the dropdown menu. You can also select more than 1 staff. * You can toggle between '**Exact Date**' and '**Date Range**'.

3. Click '**Add**'. 4. Once you have added all assignments, click '**Save Assignments**'.

Click on 'Save Assignments' button to save all changes made to the roster

{% hint style="info" %} #### Setting the order of assignees within a cell Add and save assignees **one at a time** and **in the order you want**. Assignees will appear in order from the top to the bottom of the cell. {% endhint %}

Bulk assign: Add assignments to multiple columns

1. Click 'Bulk Assign'.

2. Select one or more options under the 'Role' option. These are the columns to which the assignee will be added. 3. Select one or more staff to add to the selected roles. 4. Click '**Save**'.

Adding assignees using an Excel file

{% hint style="warning" %} Excel can only be used to **assign clinicians** for **On-Call Rosters**. It also cannot be used for modifying the template of the roster (i.e. creating new columns). {% endhint %} ### **Step 1: Go to the roster** Click '**More**'. ### **Step 2: Download template** 1. Select '**Download/Upload template for (Month + Date)**' from the dropdown menu.

2. On the pop-up, click '**Download template**'.

Click 'Download Template' to save a copy of the Excel file

3. Once the file is generated, a message should appear, 'File ready. Click here to download'. Click '**here**' to download the roster template. ### **Step 3: Adding your assignments** Choose one of the methods to add your assignments: * Using Microsoft 365 Online * Using the Excel app #### **Method 1: Using Microsoft 365 Online** {% hint style="info" %} For the latest features, we recommend using the Microsoft 365 Online version. {% endhint %} 1. Save the template onto One Drive.

2. Open a new tab and open the template on Microsoft 365 Online via .

3. To add an assignment, type the assignee's name into the excel row and click '**Enter**' to select

* Note: If you're rostering **multiple users on the same day**, duplicate the row for that date and enter each user's assignment in a new row. 4. Once the assignments are completed, save a copy of the populated Excel by navigating to **File > Download a Copy.**

Download a Copy of the completed Roster to your computer

*** #### **Method 2: Using the Excel app** 1. Save the template to your device and open it. * Template should match the template you created on Rooster. 2. Modify the excel according to your requirements and add the assignees. * If you're rostering **multiple users on the same day**, duplicate the row for that date and enter each user's assignment in a new row. 4. Save the populated Excel file on your computer.

**Example**: Filled up monthly roster on Excel

**For web version of Microsoft 365 Excel**: Download a Copy to your computer

### **Step 4: Upload Excel file** 1. Return to the 'Download/Upload Excel template**'** popup on Rooster. * If you closed the original popup, click 'More' and select 'Download/Upload template for (Month + Date)' from the dropdown. 2. Click 'Choose file**'** under **Step 2.**

3. Select the populated Excel file and click 'Upload'. 4. The system will process the file and update the roster accordingly.

{% hint style="success" %} #### Multiple users can edit on Rooster at the same time * If users are editing different cells, we will save both changes by all users. * If users are editing the same cell, we will save the latest change that was made. {% endhint %} ## FAQ **How can I add multiple assignments to the same cell in a specific order?** In order to add multiple assignments to the same cell and maintain their order, you will have to add the assignees consecutively. {% @arcade/embed url="" flowId="R3R7zofphAP9nUTmbY9w" %}