How to create a summary (count) of open tasks across sheets by contact



I have found lots of others with similar questions, but I don't seem to quite find the solution that would work for me. I have a project worksheet and an action log worksheet with contacts listed as the "Assigned To". I would like to create a summary (like an Excel pivot) of how many actions are open, closed, escalated by contact Assigned To. I wish this could be a user-friendly canned report function :-(

Is there any advice to do an index+match+count using a contact field type to get a count such as this (for a non-coder type)? Some of my fields have 2 contacts, so that adds another layer of complexity.

Please any advice to get me started would be soooo awesome.

The first image is my summary sheet and the next one is one of my detail sheets - the action log

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!