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.
Hi there! Our Account Manager today informed us that users would need to be paid members to receive and complete Update Requests going forward. I can't imagine that Form users would need to be members, but I don't know how that differs from Update Requests, since neither requires access to the underlying sheet. Is it…
This discussion was created from comments split from: Generate documents from row data.
Error occurs when opening Vault Apps in Smartsheet WorkApps. The app fails to load and displays an error message despite logging out and back in. Issue has been ongoing since last Monday
