COUNT but not if duplicated in another row

Jo Petch
Jo Petch ✭✭✭
edited 03/01/21 in Formulas and Functions


Looking for some help with a formula... really not sure where to start. I have a sheet where each line relates to scaffold that has been built which is populated by a webform. Each line has a tag number and if I count all the tags in the column Tag No, I can see how many scaffolds are in place. The webform also collects if a scaffold comes down and that same Tag No is entered into the 'Tag No Dismantled' column. What I'm looking for is a formula that counts how many scaffold are up, but not to count them if a tag number is mentioned in the 'Tag No Dismantled' column.

Hopefully this makes sense?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!