-
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…
-
Export meta data from Reports (count functions etc)
Hi Friends, I am trying to create some analysis tools at work, assume the following scenario: I have a smartsheet filled by an online form employees fill out. Each form filled and sent creates a new row in my sheet. columns like Name Location Date of entry dropdown value a dropdown value b How can I count entries and have…
-
Create an Evaluation Tool
Hi Friends, I am new to smartsheet, please be aware of that, likely some of my struggles are obsolete but I just have no idea. Problem Statement: On global business level, we created a form for employees to forward improvement Ideas to a specific team that will execute them (or not). The form entries are logged in a…