Sign in to join the conversation:
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?
Maybe COUNTIFS
Craig
Thanks Craig. I tried that formula and cant' seem to get it to work.
Thanks,
Barb
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.
Hello, am I correct in my understanding that if I need to have the Report filtered out by the "Current User", I still need to share the Source Sheet to the other user(s) by which the Report is derived from? In this case, how do I prevent sharing the confidential information of other users if I need to share the Source…
Hi Smartsheets Community, We recently got Dynamic View and I am in need of some help. I have created a Dynamic View from an existing sheet. When I click on show view, none of the data is showing up in the view. For context, I have provided screenshots below. Does anyone have any ideas on what I am doing wrong for the…
When shared to a sheet as an editor, an internal user got an an alert that "Recipients without a member seat may be limited to view access. If they are not a paid member, and they comment, edit . . . they may become a provisional member…" They show up under Seat Types & True-up as a paid Member; they are counted in our…
