We are using Microsoft Forms to have each department in our organization select if they are operating without issue or escalate when they need assistance. Each department is listed as a drop down on Forms.
For efficiency, we have worked formulas in the background on our TEAMS Excel sheet to pull in the only that day's submissions on a tab and have Conditional Formatting in place to color cells green if all items are good, and different shades of red to show they need assistance.
However, when one department submits twice that day, it will clear all of their selections for that day in our Excel tab. I can easily fix this by deleting one of their entries, but would prefer to block them from being able to resubmit.
Does anyone know how to limit to one entry per their selected department?
