Is there a function where if you modify a certain cell, the contents of another cell will be cleared?E.g. If A1 is modified the content of B1 will be cleared.
Clear cell based on modification of another cell
google spreadsheets;google apps script