Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi. I have a sheet in which we enter transactions and the date they occur. I would like to generate a report that sums the number of transactions over a certain period. This report could then be emailed or accessed via URL, etc. Is this doable? Thanks!
Hi Mike,
Yes but not in the report itself. You would need to sum the transactions on the sheet or on another sheet with Cross-Sheet Formulas. The report can then use that information.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
Thanks Andree. I think this makes sense. Other than a manual tally, what formulas would you recommend for summing (e.g. in excel, countif with a supplied range.)
Thanks again,
Mike
I missed your answer. Do you still need help?
I want to setup automation for a distribution email list. This distribution email list should be tied to each form request. Do I have to add it to the form or can I add it, somehow, to the responses sheet.
Hello, I have a question about what I'm calling an errant alert. Here is the automation Trigger: When {{XYZ date}} changes to anything + Condition - {{Status}} = Phase 1 - In Progress + Alert someone, send to contacts in a cell = {{AA Assigned}} + Alert someone, sent to contacts in a cell = {{RE Assigned}} The automation…
Hi Smartsheet Community! I would like to ask if having a large amount of data (rows and columns) in a main monitoring sheet can affect the speed or performance of Automated Update Requests. We are currently using Smartsheet for monitoring and have several automations that send Update Requests to assigned users. I would…
