Calculations across hundreds of sheets

A M

I'm waiting for smartsheet support to respond to my ticket I submitted 3/7, but I have hundreds of sheets that log when insurances policies are received and when they are coming up for renewal. How do I calculate the policies received by per week and per month across all sheets?

Paul Newcome

Have you looked into creating a row report that pulls in all sheets then filtered by date range?

A M

I'm too new to smartsheet and don't know how.

kowal

hi @A M,

maybe you can start with this video

and then follow those links: https://help.smartsheet.com/topics/Reports

https://www.youtube.com/watch?v=jtrmKfZAnb4

Paul Newcome

@A M Here is a link to a hel particle that should get you started:

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

.

A M

Thank you all!

Paul Newcome

Happy to help. 👍️