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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!