Google Sheets change tab name based on cell value of a DIFFERENT tab

Question

Ok so I currently am running this script which works perfect if you make an edit on the current tab you're wanting to change the sheet name for...

    function onEdit(e) {
if(e.range.getA1Notation() !== 'A1') return;
    var s = e.source.getActiveSheet()
            s.setName(s.getRange('A1')
                .getValue())
}

What I tried to do is use a query formula that will change the cell value based on the cell of a different tab. That didn't work, because it's not them making an edit. It's happening automatically when the cell in a different tab changes. Is there any script that would allow me to change the tab name based on the value of a cell from a different tab?

Maybe I need to be using OnChange instead? Does anyone have an example to make OnChange do the same thing?

The are no triggers that respond to changes made by scripts or formulas — Cooper
Yea I know, that's what I'm needing help with. Was hoping for an example of a trigger. — Lonestar Dads
I have to apologize for my poor English skill. Unfortunately, I cannot understand Is there any script that would allow me to change the tab name based on the value of a cell from a different tab?. Can I ask you about the detail of both your current issue and your goal? — Tanaike
Sure, example: Sheet1 and Sheet2. I want to change the name of Sheet2 based on the cell value of B2 on Sheet1 anytime it's changed. — Lonestar Dads
Thank you for replying. I have to apologize for my poor English skill again. Unfortunately, I cannot imagine your goal from Sheet1 and Sheet2. I want to change the name of Sheet2 based on the cell value of B2 on Sheet1 anytime it's changed.. When the cell B2 of "Sheet1" is changed, you want to change the sheet name of "Sheet2" (In this case, this is 2nd tab?). Is my understanding correct? — Tanaike

Muhammet Yunus Muhammet Yunus · Accepted Answer · 2021-11-04T08:55:42

You should assign the page you'd like to rename as a variable as follows

const sheet2 = ss.getSheets()[1]

and call it.

Here is a simple example code:

const ss = SpreadsheetApp.getActiveSpreadsheet()
const sheet1 = ss.getSheetByName('Sheet1')
const sheet2 = ss.getSheets()[1]

function onEdit(e) {
  if (e.range.getSheet().getSheetId() == sheet1.getSheetId() 
  && e.range.getA1Notation() == 'A1') sheet2.setName(e.value)
}

And here is a working example sheet.

Google Sheets change tab name based on cell value of a DIFFERENT tab

1 Answers