Return status of cell (blank vs. full) at today's date.
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 :)