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


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:

As always, thanks in advance for the assistance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!