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

Shawn_K2 · 2024-03-26 22:29:41

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.

Answers

hook ✭

08/13/24

Thank you very much. I'm going to try it.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

CountIfs results 0
My sheet currently has a formula tracking # of job submissions - formula had been working up until today. It now results in zeros - I'm thinking it might be the year change however original formula uses the date of Today for year and month so I'm not certain the year is the problem. Formula below - any suggestion would be…
How can count items in a multi-select column?
I have a project sheet with status and a multi-select column that lists the area(s) each project is for. I have created a metrics sheet to calculate the number of projects per status per department, however, the columns that have more than one department listed is not being counted. What I am looking for is something like…
Need another set of eyes on SUMIFS formula in Sheet Summary
Hi and Happy New Year, Hope all is going well for you. In the Project Intake Sheet, I'm using the Sheet Summary to calculate metrics for reporting. On this particular formula, I keep getting #UNPARSABLE. I haven't been able to figure it out all day. Appreciate any input you may have! Goal: To sum the values in the ARR…

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

Answers

Help Article Resources

Categories