I'm looking for a way of modifying the script shown in the answer to the question submitted via the below link

Cut/Paste projects from Google Sheet using Script

to include the current row (B) and the row above (A) when inserting the word 'CLOSE' into a given cell on the current row (B)?

Would using one of Google's 23 April 2018 updates do the trick?


Sheet.getRowGroup(rowIndex, groupDepth)

If so, could you please show examples of how these would be inserted into the script shown in the link?

  • using one of Google's 23 April 2018 updates wont do any trick. such updates are irelevant at given point by default – user0 Jun 29 '18 at 19:52
  • @user902300 Please don't introduce unnecessary formatting into the questions. It definitely doesn't make things easier to read and is distracting when overused. – jonsca Jun 29 '18 at 22:04
  • @jonsca well, what to say... sometime is the light for someone else more darker – user0 Jun 29 '18 at 22:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.