Can you trigger an automation or conditional formatting based on grouped cells/same cell value?
I'm doing a work project where we're installing 3 devices into all floors of a building. Those devices are represented in columns. Each time a device is installed, the value = "Yes". However, I need to trigger an alert or take an action only when all 3 devices have been installed into every floor of the building. In the column for building number, there are multiple rows for buildings that have multiple floors.
Does anyone know how I can create a formula or trigger acknowledging every row with the same building number has had all 3 devices installed?
Right now, I'm looking at grouping the rows that have the same building number. I'm not sure if that's a good starting point.
Help Article Resources
Check out the Formula Handbook template!