---
title: "Hotel room status board in Google Sheets · Vivified Tech"
description: "Housekeeping sets Status from a phone, the desk reads an Inspected-only view, and a cell's edit history shows who changed it. Free, about 20 minutes."
url: "https://vivifiedtech.com/guides/hotel-room-status-board/"
---

The five steps in 25 seconds

  [Download the video (MP4)](https://vivifiedtech.com/assets/video/hotel-room-status-board/room-status.mp4)

The steps from this guide, 25 seconds, no sound.

### Transcript of the video

1.  0:00

    HOUSEKEEPING

    Know which rooms are ready

    Google Sheets. Free. About 20 minutes.

2.  0:01

    1

    One row per room

    sheets.google.com/create

    COLUMNS

    Room / Status / Note

3.  0:04

    2

    Add a Status dropdown

    Insert > Dropdown

    Dirty, Cleaning, Clean, Inspected, Out of order.

    Colour Inspected green with Format > Conditional formatting.

4.  0:07

    3

    Housekeeping update it by phone

    Share > Editor

    They set Status in the Google Sheets app.

5.  0:10

    4

    The desk sees only Inspected

    Data > Create filter view

    Only assign rooms marked Inspected.

    On the desk computer.

6.  0:13

    5

    See who changed a room

    Right-click > Show edit history

    On a computer.

7.  0:16

    What this does not do

    It does not read or update your PMS.

    It shows only what staff set.

    It does not alert the desk.

8.  0:19

    Every step, with the exact statuses, is in the free guide.

    vivifiedtech.com/guides

    Link in the post.

## Step 1: Make the board

1.  On a computer, open sheets.google.com/create, or go to sheets.google.com and click **New**.
2.  Name the file "Room status board".
3.  In row 1, add three headers: Room, Status, Note.
4.  Below the headers, add one row per room.
5.  Example rows: 101 | Inspected, 102 | Cleaning, 103 | Out of order | AC repair.
6.  Keep Note for short notes about the room. Leave guest names off the sheet. A room number is enough.

## Step 2: Add the Status dropdown and colour Inspected rooms

1.  On a computer, select the Status cells below the header.
2.  Click **Insert**, then **Dropdown**.
3.  In the **Data validation rules** panel, type "Dirty", then click **Add another item** and add Cleaning, Clean, Inspected, and Out of order. Click **Done**.
4.  By default, anything typed into a Status cell that isn't on this list gets rejected, so the status words stay consistent.
5.  With the same cells still selected, click **Format**, then **Conditional formatting**.
6.  Under "Format cells if", choose **Text contains**, type "Inspected", choose a green fill under "Formatting style", then click **Done**.
7.  Colour Inspected only. A rule for "Text contains Clean" would also catch Cleaning.

## Step 3: Share it with housekeeping and the desk

1.  Click **Share**, enter each person's email address, set their role to **Editor**, and click **Send**.
2.  Housekeeping open the board in the Google Sheets app on their phones and update Status as they work through each room.
3.  On iPhone and iPad, Google says the dropdown list has to be built on a computer first; after that, staff pick an option from the list in the app.
4.  On Android, the app shows the drop-down list directly in the cell.
5.  To change a status on a phone, double-tap the Status cell and pick the new status from the list.

## Step 4: Give the desk an Inspected-only view

1.  On the front-desk computer, click **Data**, then **Create filter view**.
2.  Filter the Status column to show only Inspected.
3.  At the top right, click **Save View**, then **Save**.
4.  To name it, click the view's name next to **Name** at the top left and type, for example, "Ready to assign". Press Enter.
5.  Find it again later with **Data**, then **Change view**.
6.  To bookmark it, apply the filter view and copy the page's URL.
7.  A filter view only changes your own view of the sheet, so housekeeping are not affected by it.
8.  Google says filter views are only available on desktop, not in the Android or iPhone app.
9.  Google does not document how fast this view picks up a change made on a phone. Change one test room from a phone, then check the desk's filter view to see how long it takes.
10.  Check a room's row on the filter view before you hand over its key.
11.  Agree one rule with the desk team: **only assign a room marked Inspected.**

## Step 5: Check who changed a room

1.  On a computer, right-click the Status cell you want to check.
2.  Click **Show edit history**.
3.  It shows who changed that cell.
4.  Some changes don't show up here: added or deleted rows and columns, formatting changes, changes made by a formula, and changes from before a past version was restored.
5.  Anyone without edit access to the file can't see this history.

## Details and limits

Checked on 2026-10-25. Google changes menus, so re-check the linked pages.

### What it does

One shared list holds every room and its status. Housekeeping update it from their phones, and the desk reads it from a computer. There is one rule: only assign a room marked Inspected. It needs only a Google account and the Google Sheets app. Nothing here needs an add-on or a paid plan.

### What it can't do

-   It does not read from or write to your PMS. The PMS status and the board can disagree, so someone still has to update the PMS by hand.
-   It shows only what staff set. If nobody updates a room's Status, the board does not know.
-   It does not alert the desk when a room turns Inspected. Someone has to open the filter view to see it.
-   The filter view and the edit history both need a computer. Neither works in the phone app.

### Limits

-   By default, editors can also share the file and change its permissions. The owner controls this under **Share**, then **Settings**. Give Editor only to staff who update the board.
-   A Google Sheets file can be edited from up to 100 open tabs or devices at once, and shared with up to 600 individual email addresses. A hotel's staff list will not get near either number.
-   Google's **Create a filter** option can be unavailable on a sheet with data validation or conditional formatting rules applied, which is why this guide uses a filter view instead.

### When this stops being enough

When you want the status to come from the PMS or go back into it, an alert at the desk when a room turns Inspected, or turnaround times per room, a shared sheet cannot do that on its own.

To skip building the sheet, [Room Ready Board](https://vivifiedtech.com/guides/room-ready-board/) is our free board with the same rule: housekeeping mark rooms from a phone, the desk sees Inspected rooms live, and there is no account to create.

Read [how the no-build-fee model works](https://vivifiedtech.com/how-it-works/).

## Sources

1.  [How to use Google Sheets](https://support.google.com/docs/answer/6000292?hl=en)
2.  [Create an in-cell dropdown list](https://support.google.com/docs/answer/186103?hl=en)
3.  [Create an in-cell dropdown list (iPhone & iPad)](https://support.google.com/docs/answer/186103?hl=en&co=GENIE.Platform%3DiOS)
4.  [Create an in-cell dropdown list (Android)](https://support.google.com/docs/answer/186103?hl=en&co=GENIE.Platform%3DAndroid)
5.  [Edit a file in the Google Sheets app (Android)](https://support.google.com/docs/answer/46973?hl=en&co=GENIE.Platform%3DAndroid)
6.  [Edit a file in the Google Sheets app (iPhone & iPad)](https://support.google.com/docs/answer/46973?hl=en&co=GENIE.Platform%3DiOS)
7.  [Use conditional formatting rules in Google Sheets](https://support.google.com/docs/answer/78413?hl=en)
8.  [Collaborate in Sheets](https://support.google.com/docs/answer/9331169?hl=en)
9.  [Share files from Google Drive](https://support.google.com/drive/answer/2494822?hl=en)
10.  [Sort & filter your data](https://support.google.com/docs/answer/3540681?hl=en)
11.  [Sort & filter your data (Android)](https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DAndroid)
12.  [Find what's changed in a file](https://support.google.com/docs/answer/190843?hl=en)
13.  [Find what's changed in a file (Android)](https://support.google.com/docs/answer/190843?hl=en&co=GENIE.Platform%3DAndroid)

## Related guides

-   [How to use Room Ready Board at your hotel](https://vivifiedtech.com/guides/room-ready-board/)
-   [Hotel maintenance request form and log](https://vivifiedtech.com/guides/hotel-maintenance-request-form/)
-   [Shift handover form with a morning email](https://vivifiedtech.com/guides/shift-handover-form-morning-email/)

## Have a task like this?

Tell us the repetitive task and we'll say honestly whether we can automate it.

[Get a free assessment](https://vivifiedtech.com/contact/)