Google Sheets Trigger

[PA Verifikasi]

if I put a formula that takes value from other sheet, and then have it as a trigger would it work? the value has changed but inherently, it 'has not changed' because I've already inputted the formula there that takes value from other sheet. Is there any way to make it work?

 

[SKBHD]

@PA Verifikasi Unfortunately keeping a formula based trigger won't work for 'Send on Event' setup. You can however keep the 'Auto Send on Schedule' feature on which will trigger your automations every hour.