Sheet Summary when Request Owners Varies


I am trying to add a count of Request Owners to a dashboard. The Owner varies and I have not figured out a way to have new Owners appear. How do I include them on specific Owner Count on my dashboard. Is this possible?


Best Answers


  • @Andrée Starå I have a screenshot attached. We use this sheet to manage Risks and Issues. We do not require the submitter of the form to include the owner because they may not know. Our project managers manage this. I have a dashboard that shows a count of "unassigned" owners but also need to show a count of Risks/Issue per owner. The issue I am having is that the owner is never the same group of people, new names can be added all the time. Does this help? Thanks for your assistance!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!