Summary Data based of off a Quantity, Date and Check box Columns

Nancy Heater

Hello Smartsheet Community!!!

For a Summary data field called, "Kit #1 Shipped with Box", we need to pull the of the number of Kit #1's that have a box, that have been shipped, based on the data in the screenshot below.

Here is a link to our test sheet as well: https://app.smartsheet.com/b/publish?EQBCT=2a8f00cc49eb4021916f06af91e28095

As always, thanks in advance for the assistance!

.

Andrée Starå

Hi @Nancy Heater

I hope you're well and safe!

I've added the formula to your sheet.

=SUMIFS([Kit #1]:[Kit #1], BOX:BOX, 1, [EQP SHIP DATE]:[EQP SHIP DATE], <>"")

Did that work/help?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Nancy Heater

I hope you're well and safe!

I've added the formula to your sheet.

=SUMIFS([Kit #1]:[Kit #1], BOX:BOX, 1, [EQP SHIP DATE]:[EQP SHIP DATE], <>"")

Did that work/help?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

Hi @Nancy Heater

Hope you are fine, i fixed the formula in you shared sheet but it's better to convert it to column format formula:

=IF(BOX@row = 0, 0, COUNTIFS(BOX:BOX, @cell = 1, [EQP SHIP DATE]:[EQP SHIP DATE], 
@cell = [EQP SHIP DATE]@row))

the following screenshot shows the result:

Nancy Heater

Hello @Andrée Starå and @Bassam Khalil !

@Andrée Starå - your formula gave me what I needed. Thank you!

@Bassam Khalil - not sure what your formula was trying to do, but it wasn't what I was looking to achieve. I had to remove the formula in the column, since that data is a "manual" input field and not something that is calculated by a formula, but thank you for taking the time to look and the suggestion!

Andrée Starå

@Nancy Heater

Excellent!

You're more than welcome!