Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Technology · Advice & Questions ·

Should our Google Sheets dropdown warn about an unfamiliar status or reject it?

Technology category photographTechnology

The 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.

Discussion

5 community replies

Google Sheets distinguishes rejecting an entry outside the dropdown list from accepting it with a warning. Check the rule's advanced options before treating the dropdown as enforcement. The warning you describe is consistent with a deliberately permissive rule. Google's dropdown guidance

The transport detail is useful information. If “Confirmed” means the organiser can stop finding cover, it shouldn't include an unresolved journey. Improve the meaning of the statuses before making people choose one under stricter validation.

“Waiting” might already cover this if everyone understands what they're waiting for. A short note beside that particular volunteer could explain transport without adding a new dropdown option for every possible reason someone isn't confirmed.

I'd favour a small fixed set once the meanings are agreed. Free-form statuses make a quick scan harder for the organiser. Give helpers somewhere to explain the exception so the fixed choices don't erase it.

That separate explanation needs to affect what the organiser does next. If “Waiting” plus a transport note still means someone must arrange a lift or find cover, make that responsibility clear. Otherwise the new neat label will leave the practical gap exactly where it was.

Join the discussion

More in Technology