I have little to no experience with scripts, just start using Google Sheets. That being said I don't know if what I want is possible. I have a data sheet that keeps a continuous counting check using a
sumif on another sheets data table. This goes onto another sheet which keeps track of by showing the current count and having a data validation drop down next to it with the list (yes, no, awaiting).
What I am looking for is whenever the number increases to 5+ 10+ or 15+ to have the data validation changed to awaiting indicating the change.