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…
Why do I need to go through the system admin, who is very overwhelmed with more important issues when I want to see who on my team is using their Smartsheet license or not
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…
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.
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…
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…
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?
Today in order to share data in Reports we would need to provide view/edit access to the underneath sheet / source sheet. That's not exactly what many of users expect from Reports. This is a pretty typical task to have a data frame (source sheet) and using Reports provide access to certain portions of data to different…
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…
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…
