-
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?
-
Merged: Jump to locations within a dashboard
This discussion has been merged.
-
Formula to track issues logged for a specific year ONLY?
Hi! We currently have a log that captures issues for 2022 and 2023. I'm attempting to track our "Ops Issue" and Labeling Issue" categories for 2023 ONLY and am having a hard time with adding additional date criteria to the COUNTIF formula. The screenshot below reflects my latest attempt at capturing the 2023 data. Please…
-
Merged: Create report off of a sheet you are working live in
This discussion has been merged.
-
creating a pie chart of yes/no responses
Hi there, I have a smartsheet where 1 column is a yes/no column. I am trying to create a Dashboard with a pie chart that breaks down the percentage of yes responses and the percentage of no responses. I need some serious help, as I am getting a lot of error messages and cannot figure out where to even start.