Lookup fro database hours a restaurant is open depending on day

Topic Labels: Formulas
592 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.


0 Replies 0