google-sheets-formula

[Solved] Write in the row under the function IMPORTRANGE

by

The IMPORTRANGE() function occupies a range based on the data that queries. If you add some content within the datarange that importrange returns, the latter will break because it can’t expand. You can either restrict the range that importrange occupies: =IMPORTRANGE(“SprdID”;”All Months!$A$1:$D14″) or add content starting from column E. You can also put the importrange … Read more

[Solved] How can I make the following code move information into two columns instead of one in google sheets?

by

I believe your goal is as follows. You want to copy the cell “B” to “BW” when the cell “BY” is edited to 1. You want to run the script by a trigger. In this case, how about the following modification? Modified script: Please copy and paste the following script to the script editor and … Read more