Formula

abraxton

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?

Smart sheet.PNG

Paul Newcome

What is your existing COUNTIFS?

abraxton

RCDF

ERV

Pharmacovigilance

CMC

Patient Safety

John C Murray

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

Paul Newcome

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.

abraxton

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

Paul Newcome

Try this for the HAS function:

=COUNTIFS({NGS Workstream Requirements_Final Template Range 1}, HAS(@cell, [Primary Column]@row))