Is it possible to capture or reflect unknown category(ies) in a dashboard chart widget?

In an effort to scale up a department Smartsheet Dashboard I developed using Summary Sheet Reports for my organization, I am faced with trying to include data from a category where the category information is unknown. Meaning the category data will be input by the different departments. Is there a way to collect this unknown data entered by each department using formulas in the Summary Sheet Report that will be captured within the dashboard?

As a potential example of the issue, if each department within an organization had their own accounting codes that management wanted to see in a dashboard as a percentage of usage AND each department was not privy to the accounting codes of any other department, how would that data be captured automatically to be input into one dashboard?

Thank you in advance for any insight and/or solutions to this question!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!