Menu + Spreadsheet weekly options

  • 1
  • Question
  • Updated 4 years ago
  • Answered
So, I have a menu board powered by a Google Spreadsheet that changes daily based on tabs in the spreadsheet.

The only issue we have found is that we can only update the menu 6 days at a time, as if it's Monday, we can't update the Monday tab until Tuesday when it's no longer displaying.

I cannot think of any way around this, so wanted to post and see if anybody had any ideas on how we could do this with an extra tab or something.

Any ideas?
Photo of Eric S.

Eric S.

  • 7,412 Points 5k badge 2x thumb
  • unsure

Posted 4 years ago

  • 1
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Do you normally do the updates on a Monday?

It may be a bit cumbersome, but what about two separate spreadsheets for Monday's, where the recurrence for each Monday sheet is every 2 weeks?
Photo of Eric S.

Eric S.

  • 7,412 Points 5k badge 2x thumb
The person who would be updating would like to do it weekly on the same day (Could be Monday, could be another day).

I was thinking about changing the recurrence, but as other staff could be the ones doing the updates when required, would there be a quick way (Aside from comparing the menus, as they can be very similar from week to week) to identify which is being used this week?
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Can have a cell stating prices are effective for the week of 123.  You can even set the Gadget to a range of cells so that this small piece of information isn't visible on the Display.
Photo of Eric S.

Eric S.

  • 7,412 Points 5k badge 2x thumb
Good call! I didn't even think of that. I have a few cells with added info for them, like a snippet of HTML to identify Gluten Free options.

Thanks Neal!