-
Can Smartsheet drawdown hours used and hours remaining in a report?
I'm creating a higher level report that summarizes data from a Smartsheet. This Smartsheet contains the number of hours staff are assigned to in one column. I have an allotted number of total hours that staff can draw from. I'm wondering if there's a way that I can add the total number of hours they can use to the…
-
Merged: A way to see which reports a column has been added to
This discussion has been merged.
-
Trying to return the date if a certain row task is marked Complete
After spending some time learning about a bunch of different things in Smartsheet that aren't helping with my problem, I thought I should just ask my question. I am missing something small I think. I have tasks in my projects that need to be completed after it is implemented. I want to capture the "Execution Complete" task…
-
Calendar App: Custom Category List - Missing Options
I am currently using the Calendar App, where the source is a report. I am grouping the data by a category that exists on all sheets. However, one or more drop down options are missing in the "Custom Category List Order. Is this a bug or am I doing something wrong? The current outlier is "Tech Refresh." It does not show up…
-
Gantt bar color in Report not matching color in Sheet
I have a Report that references timelines in a Sheet, and the colors do not match between the two. Why is this and how do I fix it? At first it looked like the report bar colors were importing the colors of children tasks, but even after updating those it won't adjust on the report.
-
Dynamic view updates are not displaying in my dashboard report, how to fix?
We use a dashboard to display different reports for tracking program progress. I have my current dashboard set up to display a report that pulls from a grid. When the user clicks on the report display, it opens the dynamic view of the grid, where they can make updates using the panel. The updates to the dynamic view are…
-
Find First Duplicate in a Sheet
I am trying to find the first duplicate value with the purpose of using that to highlight another cell; however, my attempts at the first part of the process have resulted in both #UNPARSEABLE and #INVALID COLUMN VALUE. The formula I'm trying to use mimics something I've used successfully in Excel: =COUNTIF($[Master…
-
Weighted Average Summary in Reports
It would be extremely useful to be able to summarize columns by weighted average in a report. Currently only a general average is available which can skew metrics that deal with percentages. Maybe even provide the capability to input custom formulas for certain cells or columns?
-
Teamwork and Smartsheet Integrations (Zapier?)
We currently use Teamwork for project management. Our account managers update their milestone dates in Teamwork to create their job schedules at the beginning of a project and then adjust the dates as it progresses. Our organization-wide job board is kept in Smartsheet and we run several reports from it (including monthly…
-
"Show More" option for cells with long wrapped text
Request: When cells have long wrapped text that have more than 3 (or 5...) lines, truncate the rest and provide a "show more..." link to expand the rest of the text. This will greatly compress sheets and rows that contain longer text. Example: goes to Comments: I am aware that I do not need to wrap text, and that will…
