Novice user, Build Reports

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!

Find more posts tagged with

Healthcare

Reports

Product Development

Comments

Andrée Starå

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

CooperMike

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

Andrée Starå

Hi Mike,

I missed your answer. Do you still need help?

Best,

Andrée Starå - Workflow Consultant @ Get Done

Sign in to join the conversation!

Quick Links

Trending discussions

I am an Admin, but I cannot edit the workspace
I am already an Admin of a workspace, but when I enter the sheet to edit, it prompts me that I am a viewer. Has anyone encountered this situation? In the share tab, it shows that I am both an Admin and a viewer. How could a product from such a large company have such a BUG?😫
Why is % Complete not the same between Smartsheet and Microsoft Projects
I have two identical projects with the exact same data, but the % Complete in Smartsheet is 14% and the % Complete in Microsoft Projects is 4%. Which one is correct
Report not showing all rows
I have a report that's sorted ascending by name but stops in the "T" section. When I sort it descending by name it shows the missing names after the "T" section at the top but then stops in the "A" section, but not all of them. There are 2217 rows and 19 columns in the report right now, is there a limit to how many rows I…