Should our Google Sheets dropdown warn about an unfamiliar status or reject it?
TechnologyThe rota says “Waiting”, “Confirmed” or “Cancelled”. One helper typed “Probably” into a status cell, saw a warning and left it there. I had assumed the dropdown prevented any other answer.
Another helper wants to reject anything outside the list. The first says “Probably” describes the situation better than any of our options: the volunteer has agreed but hasn't confirmed transport. The sheet is meant to tell the organiser which places are covered.
Should I tighten the rule or change the choices? A tidier column would help, but I don't want the sheet to turn uncertainty into a confident answer just because we've run out of permitted words.