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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • RCDF

    ERV

    Pharmacovigilance

    CMC

    Patient Safety

  • John C Murray
    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
    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.

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • 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
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!