Summary across sheets
I have two work plans with folks assigned to tasks and want to be able to see how many tasks on each sheet the person has assigned to them. For example (not in terms of formatting)
Person A: Sheet X=# | Sheet Y =#
Person B: Sheet X=# | Sheet Y =#
I have a report grouped by person that has both sheets feeding into it but the summarize option only counts the total number of tasks in the report by person (e.g., Person A: Sheet X&Y=#). In order to see the breakdown by person and sheet, would I use the summary feature in the sheets, create a separate sheet with count if's of some sort, do something different with my report grouping, or something else? I am lost in all the options and which one will do what I need.
Help Article Resources
Check out the Formula Handbook template!