I have a sheet that list vendors, end customers, and fiscal weeks, and PO's, and a q for that vendor

Options

I am trying to put on a dashboard the number of vendor PO's that are due that week, as well as the quantities that are due that week. I currently have a report that will extract the distinct list of vendors but I am trying to get the numbers of PO's due by week as well as the actual quantity by vendor due that week.


Answers

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    Options

    How many sheets are involved? Can you use some =COUNTIFS() functions in the Summary panes and use Summary Reports to pull the data through to the dashboards? Then you can use Chart widgets on the Summary reports to show as charts?

    Or could you set up a grid sheet with =COUNTIFS() functions to pull the stats into one place?

    Within the report, you can use Group and Summarize tabs to count per group then you can put a shortcut to the report on the dashboard?

    Would any of these help?

    Kind regards

    Debbie

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!