Formula
I am building on my Dashboard, and I am using the Countifs formula to input data into my metric sheet.
I now have certain parts of the document that has multiple options that I would like displayed. Is that possible?
Answers
-
What is your existing COUNTIFS?
-
RCDF
ERV
Pharmacovigilance
CMC
Patient Safety
-
It is difficult to work out what you are trying to do without an example or your existing formulae.
So this answer will assume that you want to have those five metrics displayed separately on your dashboard.
Create a new sheet with just a single row that contains all the different bits of summary data that you need to display on your dashboard. For example, to list the number of events in each category today you would do something like:
- Column "RCDF" formula =COUNTIFS({Issue Category range},"RCDF",{Date range}, TODAY() )
- Column "ERV" formula =COUNTIFS({Issue Category range},"ERV",{Date range}, TODAY() )
- ... and so on
Then add Metric widgets for each one on your dashboard
-
I meant the formula you are currently using. What is that?
I am thinking you are most likely going to need to incorporate the HAS function, but I can't say for sure until I see what you are currently using.
-
apologies, this is the formula I am currently using: =COUNTIFS({NGS Workstream Requirements_Final Template Range 1}, [Primary Column]@row)
I currently have those metrics displayed separately.and would like the ones that have multiple selections to be displayed as well
-
Try this for the HAS function:
=COUNTIFS({NGS Workstream Requirements_Final Template Range 1}, HAS(@cell, [Primary Column]@row))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- New program proposals are submitted via a form and collected on Sheet 1. When approved by a team leader, the row is copied to Sheet 2. I want to capture the date the copied occurred, which I thought w…
- I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
- Hi, I'm looking to write a formula using references to a rate sheet (screenshot attached with sensitive information redacted). We have several types of rates here, and also ones that are per word, whi…