Create a sheet summary, which counts RAID items and their statuses from another sheet

Hi there,

I have a RAID log called "Work Allocation RAID Log" and I would like to create a Summary Sheet so I can see all the types and counts based on status - please see below

Type (primary):

Action
Decision
Dependency
Issue
Risk

- with their statuses (columns):

Not started
In progress
On hold
Completed
Cancelled

This is the column structure for the RAID Log:

ID
Show on Report
Escalate?
Type
Workstream
Sub Workstream
Status
Lead
Collaborators
Priority
Due Date
Short Description
Latest Updates
Overdue?
Mitigation
Additional Raised by
Modified By
Modified
Raised By
Created

I am selecting from 'Type' to 'Status' columns (4 in total) and however the formula below is not working.

=COUNTIFS({Work Allocation RAID Log Type}, "Action", {Work Allocation RAID Log Status}, "In progress")

What am I doing wrong please? Thank you

Find more posts tagged with

Formulas

sheet reference

Accepted answers

All comments

kowal

hi @JGei ,

from this screenshoot it looks everything is setup properly but invalid ref error shows there could be something wrong with the sheet you are reading your data from. can you share yours screeen how you mark those columns in source sheet.

Also you can optimse a bit this formula as you keep the type in Aprimary Column you can use this:

=COUNTIFS({Work Allocation RAID Log Type}, [Primary Column]@row, {Work Allocation RAID Log Status}, "In progress")

JGei

Hi @kowal ,

The Status column is a drop down list, so I cannot use it as the primary.

Below is the screenshot on how I am selecting the columns. Thank you for your help.

JGei

I have managed to do it. I had to add 2 references for it to work

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.