Count Check marks across columns

slickmouse

Hi I'm relatively new to SmartSheet and have a question.

I have a set where each row represents a requirement.  Each requirement may impact multiple systems.  Since I'm unable to select multiple entries with a drop down - I've created 4 column - each representing an impacting system.  I now need to summarize in a dashboard how many impacts each system has.  So for System A - x # of requirements impact it; System B - y # of requirements impact it.  How can I make that happen?  I tried creating a summary sheet and linking - I ran up against the 25,000 cell limit for links to external sheets.  I'm sure there is a better way.  

Andrée Starå

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, [email protected])

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting