How to loop Google Sheets paste transpose formula in Google Script
51 views
Skip to first unread message
massimo vigano
Oct 25, 2021, 8:48:21 AM10/25/21
to Google Apps Script Community
In the attached example file where in sheets “Peter”, “John”, “Albert” I inserted the following formula in B4,C4 (October), B42,C42 (November)
=transpose(query({Planning!A3:DT3};"Select "&ArrayFormula(join(", ";text(query(transpose({column(Planning!BM3:DT3);mod(column(Planning!BM3:DT3)-column(Planning!BM3);2)});"Select Col1 where Col2=0");"Col0")))))
I should insert formula in 35 sheets for six mounth planning. How to loop this formula in a function?
https://docs.google.com/spreadsheets/d/1P6Nu90yQQWCdi4Bq14gVXpdZh_TMFsSxxtGjbrmZizU/edit?usp=sharing
Reply all
Reply to author
Forward
0 new messages