Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Lookup fro database hours a restaurant is open depending on day

Topic Labels: Formulas
376 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

0 Replies 0