Dashboard - Chart Help, multiple responses in one column
hello,
I am trying to create a graph with the data below, however I cant figure out how to capture the work type count when there is multiple options in that column. The formula i am using is in the screenshots attached (count by processor) - hopefully that gives you enough to help me out!
Best Answer
-
Try this:
=COUNTIFS({PEER REVIEW ADMIN Range 1}, HAS(@cell, $[Primary Column]@row), {PERR REVIEW ADMIN Range 2}, @cell = [Column2]$1)
If you enter the above into the top left corner of the table ([Column2]2), you should be able to dragfill this down and to the right to fill the rest of your table without having to manually update names or work types within the formula.
Answers
-
Try this:
=COUNTIFS({PEER REVIEW ADMIN Range 1}, HAS(@cell, $[Primary Column]@row), {PERR REVIEW ADMIN Range 2}, @cell = [Column2]$1)
If you enter the above into the top left corner of the table ([Column2]2), you should be able to dragfill this down and to the right to fill the rest of your table without having to manually update names or work types within the formula.
-
@Paul Newcome - do i need to change something in that formula to make it work because I copied that in and it gave me #INVALID REF
-
nevermind, i found peer spelled wrong in the formula - got it to work. thanks!!
-
Sorry about that. Glad you were able to get that corrected.
happy to help. ποΈ
