-
Reports column problem
Hello, I have added a column that is a dropdown list allowing multiple values per cell. It shows up and works in the main sheet, however, the report will not show the options. What is going on??
-
Update Request Links
Hi - I'm wondering if there's any way to capture the actual Update Request link (what comes through in the email when you send the Update Request) in a report? Our account people get tons of Update Requests, and don't always have the info to follow up immediately. So, rather than have to sift through emails, is there an…
-
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?