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

Shawn_K2 · 03/26/24

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 · 03/26/24

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 · 03/27/24

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

Received #INCORRECT ARGUMENT SET error

Andrée Starå · 03/27/24

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 · 03/27/24

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

Paul Newcome · 04/01/24

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å · 04/02/24

@Shawn_K2

Ok.

Did it work with Paul's suggestion?

Shawn_K2 · 04/02/24

@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 · 04/02/24

Try this instead:

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

Shawn_K2 · 04/02/24

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

Paul Newcome · 04/02/24

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 · 04/02/24

Ok. Thank you!

Paul Newcome · 04/02/24

Happy to help. 👍️

Shawn_K2 · 04/02/24

@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 · 04/02/24

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)

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

Answers

Help Article Resources

Categories