Clear Cell Content (A2) if the value of another cell(A1) is equal to a specific text

Asked

Viewed 72 times

2

Please someone can help me with the following case:

I have a spreadsheet in Google Sheets;

I need a script to clear the contents of a given cell (A1) IF the text of another cell (A2) is equal to a specific text ("TABULATED VALUE")

Thanks for your help. Rodrigo Wolff

script google-sheets

2 answers

0

A simple solution would be to use an auxiliary column with a function IF and would serve for some kind of calculation.

inserir a descrição da imagem aqui

-1

Another option: Programming in javascript using onEdit specifically ().

 function onEdit(e) 
   {
     se estiver na aba certa
       {
         se a celula alterada é a A2 
           {
             se foi alterada para "VALOR TABELADO"
               { apagar celula A1}
           }
       }
   }

Any questions, we’re here. A hug.

Browser other questions tagged script google-sheets

You are not signed in. Login or sign up in order to post.