Folks,

When using the ui show modal dialogue method,it asks the user to authorize operation of the function, which is quite normal.
However, with the only this document notation at the top, it still asks the user to authorize full drive access.

I have 2 columns . A and B – there is a list of project names and maybe duplicate (which is Ok) in column A. and there is a list of numbers related to that project name in column B.

In Google Sheets we have one sheet called InvoicingPeriods:

I have a billing invoice where I need to have a code and the last three digits incrementally increased by +1 every half of every month.

I would like a calculation that give me a rolling 12 weeks average, I will continue to add to the sheet and want it to automatically update the average as more dates are added. Thanks!

Would like some advice here please.

I have more than one Google sheet, but they all have the same titles. These sheets will be filled by different departments. However, the point where I have a problem is that every information people fill out must appear on the master sheet. I couldn’t figure out how to do this (it didn’t work when I tried what was written). Actually, what is wanted is exactly this. There are 4 different departments and about 8 titles they need to fill. When each department makes an edit to its own sheet, the edit must be transferred to the master sheet. How can I do that.

Here is the link to the spreadsheet
https://docs.google.com/spreadsheets/d/1IKtSgeneUy5esKV9dIk_cEbMKm1vda5YpCqMo279k04/edit?usp=sharing

I’ve a cell for example A1 that its content is, let’s say =B1 that resolves to a dummy string. From A1 I want to extract the “B” value (the column) from the =B1 formula (not the text that is resolved), is there a way to do this?