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

Shawn_K2

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.

Scott Orsey

Hi @Shawn_K2 , Have you attempted to create a report and specifying the filters that you listed? If not I would try that route first to see if that meets your need.

Within reports, I would recommend looking into Filters, Grouping, and Summarize. These are all features that you can find solid help for within the community.

If you make a little progress, but need some additional help, share a little more about what you've tried. I'm happy to help, but it's hard to describe without knowing what you've been trying.

I hope this is gets you going in the right direction. Be well!

Shawn_K2

Hi! I've tried to create a formal: =COUNTIF({Photo Shoot Date}, {Brand}, "Baby Einstein")

Received #INCORRECT ARGUMENT SET error

Andrée Starå

Hi @Shawn_K2

I hope you're well and safe!

Are you referencing another sheet or is everything in the same sheet where you add the formula?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Shawn_K2

Hi @Andrée Starå - I'm referencing another sheet. Adding this info to a summary sheet

Paul Newcome

You are going to want to start with a COUNTIFS (with the "S" on the end) so that you can include multiple range/criteria sets.

The other thing would be... What is the criteria for the date column? Is it a specific date or date range, or is it just "not blank"?

https://help.smartsheet.com/function/countifs

Andrée Starå

@Shawn_K2

Ok.

Did it work with Paul's suggestion?

Shawn_K2

@Paul Newcome @Andrée Starå The criteria would be photoshoot complete column "not checked" complete.

So I guess would need a formula like:

=COUNTIFS({Photo Shoot Date}, {Brand}, "Baby Einstein", "0")

"0" for unchecked photoshoots?

4 range/criteria sets: Brand, Brand Name, OW Shoot Date, Photoshoot Complete

Final result is to have the total number of photoshoots not completed by Brand.

Paul Newcome

Try this instead:

=COUNTIFS({Brand Range}, @cell = "Baby Einstein", {Checkbox Column}, @cell <> 1)

Shawn_K2

Prefect! I just change @cell <>1 to @cell <>0 if I want the unchecked items @Paul Newcome

Paul Newcome

No. @cell <> 1 is counting items that are unchecked. <> means "not equal to" and 1 means "checked. Thus @cell <> 1 means "the cell is not equal to checked".

Shawn_K2

Ok. Thank you!

Paul Newcome

Happy to help. 👍️

Shawn_K2

@Paul Newcome Now what if I want to include items that have dates, but are not completed.

So - Brand, Brand Name, OW Shoot Date, Photoshoot (Not) Complete

=COUNTIFS({Brand Range}, @cell = "Baby Einstein", {OW Shoot Date}, @cell <> 1, {Checkbox Column}, @cell <> 1)

Error - #INVALID REF

Paul Newcome

That particular error comes from a {Cross Sheet Reference} that wasn't set up properly. Double check that each {Range} has been set up according to the proper steps.

Then your criteria for the date range would be

@cell <> ""

(not equal to blank)

hook

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