Summarizing a column based on another multi select column
Hello - I have a column named "Monthly Hours" that lists hours (integers). I have another column called "Site of request" that lists the site(s). That column is multi-select. I would like to summarize hours spent per site. So, if the "Monthly Hours" column has a 10, and the "Site of request" lists "Site A" and "Site B", and if another row has 5 hours for just "Site A", then it would summarize 15 for A and 10 for B.
The ultimate goal here is to graph monthly hours per site.
Help Article Resources
Check out the Formula Handbook template!