Needing a formula that shows how many requests get entered each month

hjarriaran

I am building a ticketing system and need to identify how many specific requests get entered each month by a specific department.

It would need to use the Request Type "Template Request", the Division "Primary Care Lebanon" and the Request Entered Date.

Andrée Starå

@hjarriaran

I hope you're well and safe!

Have you explored using a Report?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

hjarriaran

Andrée Starå

Sep 12, 2023

@hjarriaran

I hope you're well and safe!

Have you explored using a Report?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

@Andrée Starå

Hi! Hope you are well.

Unfortunately a report won't give me the specific data that I am needing.

Paul Newcome

You would use a COUNTIFS. If it is on a different sheet than the source data, you would use cross sheet references.

COUNTIFS Function | Smartsheet Learning Center

https://help.smartsheet.com/function/countifs

Counts the number of times all given conditions in their respective ranges are met.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references