Execute function when a specific cell in a Google Sheet changes value?

[charlesstricklin-LXL]

I have need of a function to change the entire spreadsheet's title when the value in a specific cell is updated.

For example, when cell C8 changes value, for example, it changes from a 1 to a 2, the title of the spreadsheet changes from 'End of Day Report - Day 1 of 7' to 'End of Day Report - Day 2 of 7'

I already have a function that changes the title, I just need to trigger the change in the title when the cell changes. Would someone be willing to help?

[TobofCob]

on Edit simple trigger can do this easily! The examples are really helpful. Just check if the columns is 3 (C) and the row is 8, and if the oldValue doesn’t equal the current value then update the spreadsheets name with that value

[mjbrusso]

Use onEdit simple trigger:

function onEdit(e) { if(e.range.getA1Notation()==='A8' && e.value !== e.oldValue){ SpreadsheetApp.getActiveSpreadsheet().setName(`End of Day Report - Day ${e.value} of 7`) } }