nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Count of Requests/Emails Per Day

bbloch18

I am able to calculate today number of requests and total number of emails.

I want to be able to calculate requests per day and emails per day.

What is best function to use?

2018-08-08 14_45_20-SAB Activity - Smartsheet.com_.png

Find more posts tagged with

Comments

J. Craig Williams

Maybe COUNTIFS

Craig

bbloch18

Thanks Craig. I tried that formula and cant' seem to get it to work.

Thanks,

Barb

J. Craig Williams

This would show the number of times that [Request Date] matches the date in the same row.

=COUNTIFS([Request Date]:[Request Date], [Request Date]@row)

This would show the number of emails per day

=SUMIFS(Emails:Emails, [Request Date]:[Request Date], [Request Date]@row)

I would use this in a header section, not on each row, but either works and has use cases. If I want to reuse the [Request Date] in my header, I would also check if the Brief Desciption column was blank, so I didn't count the header section by mistake

=COUNTIFS([Request Date]:[Request Date], [Request Date]@row, [Brief Description of Request]:[Brief Description of Request], NOT(ISBLANK(@cell)))

=SUMIFS(Emails:Emails, [Request Date]:[Request Date], [Request Date]@row, [Brief Description of Request]:[Brief Description of Request], NOT(ISBLANK(@cell)))

I hope that helps.

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

Smartsheet and Excel
Can excel sheet be used as a reference in Smartsheet?
Why does Smartsheet show the following "You have 4 days left on your business trial plan"
I have a State account
Forms only for new row items?
Hi Can you utilize forms to make data entry easier into a row that already exists?. For instance, if I have pre-populated a sheet with 100 rows/items can I use a form to update certain columns in these rows…to make columns with multiple lines of text easier to enter? Many thanks Matt