In Google Sheets, How Do You Change The Sheet That The User Sees?
I have a Google Sheet spreadsheet with some javascript code in it. The user(s) begin on a default sheet and the code creates and names a sheet based on the user that is accessing i
Solution 1:
Try it with ss.setActiveSheet(ss.getSheetByName(username))
since the documentation states that 'Google Sheets UI displays the chosen sheet'.
Baca Juga
- I'm Trying To Make An Id Searcher Which Does A Thing When You Input The Right Id. However, The If Statement Always Runs. Why Is This?
- Gas: How To Change A Global Variable Value And Preserve Its Changed Value When Using The Variable In A Handler Function?
- Google Apps Script - Using For Loop To Pull Data From Range Based On Condition
Post a Comment for "In Google Sheets, How Do You Change The Sheet That The User Sees?"