Relative Content

Tag Archive for google-sheetsgoogle-apps-script

I want to use a macro to check a value in a sheet and return one of two values

I have three tabs on my Google Sheets – called “Credentials”, “Credentials-fullsales” and “Credentials-reservations”
I need a Macro that goes to each of those tabs, checks the contents of cell B4. If there is a “1” in there, it needs to change it to “2”. If there is a “2” in there, it needs to change it to “1”

I want to use a macro to check a value in a sheet and return one of two values

I have three tabs on my Google Sheets – called “Credentials”, “Credentials-fullsales” and “Credentials-reservations”
I need a Macro that goes to each of those tabs, checks the contents of cell B4. If there is a “1” in there, it needs to change it to “2”. If there is a “2” in there, it needs to change it to “1”

I want to use a macro to check a value in a sheet and return one of two values

I have three tabs on my Google Sheets – called “Credentials”, “Credentials-fullsales” and “Credentials-reservations”
I need a Macro that goes to each of those tabs, checks the contents of cell B4. If there is a “1” in there, it needs to change it to “2”. If there is a “2” in there, it needs to change it to “1”