How to count the number of photo shoots, not completed, by brand? COMPLEX???


Trying to get the summary of the amount of photo shoots from one column, not checked completed from second column, and sorted by the brand by third column.

So three columns.

(Brand column with specific brand) + (OW Shoot Date column) + (Photo Shoot Complete column) = Total shoots by brand.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!