Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Can you trigger an automation or conditional formatting based on grouped cells/same cell value?

Hello,

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.

Thank you!

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions