Return status of cell (blank vs. full) at today's date.
Hello!
I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have a vacant/occupied indicator on a SS dashboard.
My test sheet is below:
So, to determine whether Desk 1 is occupied or vacant, I attempted to use the following function in a summary field:
=IF(isblank(INDEX([Date]:[Desk 5],MATCH(Today(),[Date]),[Desk 1])),"Yes","No")
w/ "Yes" being vacant and "No" being occupied
Can someone please tell me where this function is going wrong? I keep getting unparseable errors. Much appreciated :)
Warmly,
Clay
Best Answer
-
Hello,
According to your description, this is all you need
=IF(ISBLANK([Column1]@row), "Yes", "No")
But I'm sure there is more in to it, would you mind to explain what are you trying to achieve with the INDEX part ?
Answers
-
Hello,
According to your description, this is all you need
=IF(ISBLANK([Column1]@row), "Yes", "No")
But I'm sure there is more in to it, would you mind to explain what are you trying to achieve with the INDEX part ?
-
Hi, Alex!
Thanks for the reply. I was trying to accomplish this in a summary field, which I believe would have required an index function of some sort to locate the value @ today's date. However, due to other issues in the sheet's structure, I think I will use a helper column w/ your =IF(ISBLANK... function, instead. Thank you!
-Clay
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!