Check room availability for same date.


Hello Smartfamily !

I have a sheet where I need to check if a room is available for the same date.

The screenshots below shows how the column "Availability" SHOULD behave.


For the date April 24 2023, I select Room 1. Room 1 is not already selected for that date so "Availability"@row shows a checkmark

As soon as I select Room 1 again for the same date, "Availability" shows a X so I can easily see that it's already been selected.


What is the formula I should have in the "Availability" column?

Thank you ! Keep being Smart !


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!