Hello, my friend!
Look, I’ve been looking at the forum to see what I want to do, but it doesn’t work for me.
I tried to create a google script.
But I find that the way the trigger should work is onEdit however I have read that through Glide you must use onChange for the script to work.
if(SpreadsheetApp.getActiveSpreadsheet().getSheetName() == "Simulador")
//Poner número de columna que se va a modificar//
var range = e.range;
if(range.getColumn() == 4)
//Poner nombre de hoja y número de columna donde nos traerá la fecha//
SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Simulador”).getRange(range.getRow() , 5).clearContent();
The previous one is the script I made but when I make a cell change from the App it is not edited, it is only edited if I do it myself by opening the google sheet. As I read and as I said you should use the onchange but I have no idea.