Request type by project

Hello,

I'm having difficult trying to report on metrics that would outline the following:

Identify the number of request types by project

For example, if you have 5 projects, all named differently and 2 request types (new/existing) and you wanted to report in a sheet, to then carry over to a dashboard the number of requests by project.

project 1 - 2 new request types, 1 existing

project 2 - 1 existing, 0 new request types

project 3...

Currently, I have a master sheet where data from a web form flows. I then have another "metrics" sheet where I have columns linked from the master sheet that I use formulas in. The formulas are populated in the metrics sheet and then linked to a master dashboard.

Any thoughts? Thank you for your support!

Find more posts tagged with

Formulas

Comments

eric.o

Hello,

If you're finding your COUNTIF isn't accurately counting the desired values selected, it may be that the spelling of the criteria in the row doesn't match exactly with that which lives in the source sheet. You'll want to confirm the spelling is exactly the same capitalization and all.

Also, you may want to confirm the column being referenced for the Range is the correct column and contains the correct data.

Note: The dashboards are displaying as 0 because there are no values within the reference.

COUNTIF: https://help.smartsheet.com/function/countif

CROSS-SHEET: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

Cheers,

Eric

Smartsheet Support

mmac

Thank you for the reply.

More specifically, what I am trying to accomplish is showcase of the various campaign projects, of those requests, how many are new versus a change request.

For example, if project 1 has 4 changes, how many of those 4 changes linked to project 1 are new versus change requests.

mmac

Following up to see if anyone in the community may have any thoughts and be able to assist. Thank you!

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?