Is there a way to have triggers that only activate when certain selections happen on one specific sheet? For example I want something to trigger on a certain selection when they are on the first sheet, but if they select that on another sheet, I don't want the trigger to activate.
This didn't work for me because i still want it to respond to other selections. I tried doing an
if (match([Field],'name1','name2','name3','SH20') This works but I want it to only trigger when the selection goes from 0 to 1. For example if name 2 is already selected and I clear something out or make another selection for a different field the trigger activates. Is there a way to make it so the trigger only activates the first time it is selected? Help would be much appreciated.