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

Navigation
2

Please someone can help me with the following case:

I have a worksheet in Google Sheets;

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

Thank you in advance for your help. Rodrigo Wolff

    
asked by anonymous 06.09.2018 / 17:13

1 answer

0

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

    
08.09.2018 / 03:56
Alternative connection for WebService How do I capture each key typed in python