Formula to Match cross sheet and COUNT instances.


Hello Smartsheet Community!

I'm trying to create a formula that generates an integer value based on two criteria.

I have one sheet that acts as a repository for all of the daily activity at multiple sites, for each day of the year.

My formula needs to MATCH [Date@row} to the cross sheet reference range {Master Shipment Log - Date}. For all instances with a matching date the formula then checks the {Master Shipment Log - Site} and counts all instances that Match the individual sites.

Since this is checking 2 conditions would this require an INDEX(COLLECT instead of INDEX formula?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!