Hey guys,
I made the following formula on Google Sheets: =LOOKUP(WEEKDAY(J2),B1:H1,B2:H2)
Where J2 has the =Today() function, B1:H1 tells the function what day of the week it holds and B2:H2 what its operating hours.
I am looking to use the lookcup function on Airtable, and depending on =today() date find out from the spreadsheet a respective operating hour of a certain restaurant.
Thanks.
