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

Writing Formulas in Smartsheet - Self Paced - Optional Activity
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
More granular time options for needed for Workflow triggering
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
"has any of" criterea is only pulling the first item in the cell
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…