I’m trying to make a calendar. I want rows 2-37 hidden if someone presses a shape in January, 39-74 if they press it in February etc. The script should take into account the sheet as well. So it only hides rows 2-37 on the active sheet not the sheet next to it.

Following situation.
I have a drop down table in a cell.
The drop down options are taken from a range of cells, A1:A20 for example.
The cells in A1:A20 have different background colors.
When creating the drop down from the range A1:A20, the background color of all drop down options is white.

Exception: Service Spreadsheets failed while accessing document with id [insert doc ID code here]

I have a Google Appscript that has been running perfectly for some years. The script sums cells based on the background colour of the cell.

I have a Google Appscript that has been running perfectly for some years. The script sums cells based on the background colour of the cell.

I have a Google Appscript that has been running perfectly for some years. The script sums cells based on the background colour of the cell.

I have a Google Appscript that has been running perfectly for some years. The script sums cells based on the background colour of the cell.

I have a Google Appscript that has been running perfectly for some years. The script sums cells based on the background colour of the cell.

I am trying to build an online repository for simple information, where a user can enter/edit their own data, and view the rest of the data. Essentially, each user would have edit access to their own single-row in a table. I want to minimize set up/maintenance of “accounts”; I want this to be a no-cost solution.

I see that the concept of table was introduced in Google Sheets so I want to get that data in google app script: