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 !
Answers
-
@Francis PJ P. Is this data all kept in one sheet or will you be referencing another sheet that contains the room numbers?
-
@Francis PJ P. try something like this
=if(countifs(room:room, room@row, date:date, date@row)>1, "No", "Yes")
-
All in one sheet. :)
-
This works ! Thank you!
I have "upgraded" your suggestion a bit so that if no room has been selected, the Availability row does not show a green checkmark.
=IF(Room@row = ""; ""; IF(COUNTIFS(Room:Room; Room@row; Date:Date; Date@row) > 1; "No"; "Yes"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!