Force a user to choose an option from a dropdown
I have a Sheet for daily tasks.
Column C contains a dropdown with 3 options: "Done", "In Progress" and Waiting for Parts"
In Column F, I have another dropdown with the names of technicians. The problem is that some technicians choose "Done" but don't choose their name from the second dropdown. leaving us without a clue who completed the task. is there a way to make the technician choose their name first before choosing "Done" in Column C... Please advise.
Posted May 25, 2024, 6:32 AM UTC
116