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

logos from other companies appearing in approval and update request emails?
Is anyone else experiencing an issue where logos from other companies are being included in the email notifications from approval and update request automations? Yesterday, we noticed that our approval request and update request emails are showing company logos from other organizations rather than either our own logo, or…
RAID Log for Program
Hi All, I’m looking for some ideas and suggestions regarding RAID logs. I currently manage a portfolio of 18 projects and would like to align each individual RAID log with a program-level dashboard. Does anyone have a RAID log template they’d be willing to share? Additionally, I’d appreciate any guidance on how to…
Can't access issue submission
I have run into an interesting but small bug. When setting up an automation, the action 'change cell value' will allow you to select checkbox columns, but not checkbox columns that are the star or flag visual variant. Those can't be selected in the change value action. Now the real issue. I go to submit a bug report or…