-
Top 5 Producers Chart Creation
Hello! We want to post a top 5 (or 10) list on a dashboard to dynamically display producers with the top 5/10 highest total sales in both count and $ amount. We have a master sheet to capture this information but cannot find the right formula or approach (maybe a helper column?) to produce this. Any help is greatly…
-
Current User report filter not working on Dashboard
I have created a project Homepage using a Dashboard and would like to be able to display a list of actions, risks and issues owned by the "Current User" on this dashboard. To do this, I have created reports for each of these items and, using the report builder, filtered the data to show records that have Current User in…
-
Summarize data by totals
Summarize data on reports by totals, so that on the dashboard, the charts can show data from highest to lowest (total numbers), and not just in alphabetical order.
-
Power BI Report Builder
Hello, Could SmartSheet data feed into Power BI Report Builder? Thanks, Michael
-
Line # Reference in Report
Good morning, Is there a way to show the original line number from a timeline to a report? I have a timeline Gantt for a project in one sheet. I have a to-do report based on the due dates in another sheet. In the report, I would like to reference the line that the item is found on the original project sheet so that it can…
-
Report on tasks for the next 3 weeks
Hello, I am trying to create a report view of my company's work schedule that only shows tasks happening over the next 3 weeks. I have tried using a combination of filtering by start and end dates in the next or last ____ days, however the problem is that it doesn't capture every task. For example, if there is a one-month…
-
Merged: Add a column to a row report to perform calculations to summaries / groupings
This discussion has been merged.
-
I'm getting below error when trying to add a chart to my dashboard
Dear community, I'm looking for your help if you have come across a similar issue when creating a dashboard. I'm wondering why the data cannot be charted.
-
Row Report, Count Distinct and Summary Formula?
I have a row report that I am building off of a sheet that includes the date, name, and time spent on a task. I am wanting to build a row report grouped by name, that summarizes the sum of the time spent on a task and the count of distinct dates. The part that I am struggling with is counting the distinct dates, as I only…
-
What is the maximum number of rows that can be added to a sheet?
I've searched for 'Row Limitations' on the help center, and haven't found an article which explains clearly so asking here. What is the maximum row limit (vertical, up to down) on a single sheet? I've seen both 5000, and 20000. Additionally, is there an article where this information is contained?
