Calculations across hundreds of sheets

A M

A M ✭

03/13/25 in Smartsheet Basics

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?

0 ·

Answers

Paul Newcome Community Champion

03/13/25

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

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter
A M ✭

03/13/25

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

0 · Share on Facebook Share on Twitter
kowal Overachievers Alumni

03/14/25

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

Tomasz Kowalski
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

03/14/25

@A M Here is a link to a hel particle that should get you started:
https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports
.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter
A M ✭

03/14/25

Thank you all!

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

03/14/25

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

New User..
Hello, I am a new user to Smartsheet and have a question on Saved Automation Workflows. I am trying to edit the email by adding a due date in the subject line of the email once it reaches a trigger date. Please advise on how I can change the due date from month.
auto-resend update (or approval) request after 30 days
I have some automations set up where the work is intensive (or people forget) and update (or approval) requests sit for more than 30 days. The notification center wipes these requests out after 30 days and although they sit in email, people seem more likely to completely forget about these completely. Does anyone know a…
Adding Contacts To Contact Columns
In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for "sharing". I want to share sheets with my whole operation (75+ people), but having to individually…

Help shape the future of Smartsheet.
Share your ideas and feature requests.