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.
Dec 15, 2019
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.