-
Median and Mode options in Report Summary Options
We use Median for a lot of metrics as it helps to remove the outliers that can skew the data. Please add Median and Mode (if you are already updating it 😉) in the summary options for the reports.
-
Display Conditionally Formatted Data from an RSS Feed
Hello Community - I successfully created a SmartSheet that populates the Top Row with the most recent RSS feed data. This RSS data adds a new top row to my SmartSheet every hour. I created several formulas in the SmartSheet to display a conditionally formatted value (e.g. red, yellow, or green fill). I have about 10…
-
Report from 2 Sheets
i was trying to Link 2 Sheet together. in 1 report. they both have alot of the Same info on them but one sheet has % and the other is a Check box. i would like to not add another Column as the Sheet is very large and it has hit the Max cells. here is a Screen Shot of how i can get it to look but what i would like to try…
-
Wrap not working on "Latest comment" column
It seems as though the wrap feature is not working on the latest comment column. Trying to utilize this in a weekly WIP report and need the text to wrap to see the comment. See attached. I have 2 other columns that are wrapping fine in the report.
-
"Current User" Report filters applied to report widgets on Dashboards
Usually report filters carry over to reports in a widget on a dashboard. However, the Current User option in report filters does not carry over. This would be very helpful in building dashboards and reports so I only have to build and maintain 1 of each rather than build multiple of each for each manager/area I want it…
-
Report data not visible to those with access
Anyone else experiencing this just recently? I have a handful of people not able to see Report data (some or all - depends on the report and it's happening on a ton of them) that they should be able to see and have access to? It's not an access/ sharing permission issue. There is not a current user filter on the Report.…
-
Prevent Report Column Name from Printing... (same as is available for row #'s)
I often use columns for multiple purposes and the main column name is not always applicable. I can get the appropriate rows to show and even designate alternative column names in a row. I can even make this row show up where needed in the report. However, when the report is printed to PDF the column names cannot be toggled…
-
Several tests on the Same Object need help with Report and Layout
I have an experiment where I test object a, b, c, d. The variables (columns) will be height, weight, fill with fluid etc. however I might have changes for the test objects and re-run the experiment where I poke a hole in (a) and therefore need it to be tested again. How do I create a report that shows all tests a-d and…
-
Is there a way to filter a report for a dashboard to only display the cells for today?
I am working on a dashboard which displays the task schedule for my staff. What I am trying to get working is a report widget that shows additional assignments for the active day. I have the report built… But, I am struggling to filter it in a way it only shows the assignments for today. Currently it is showing the whole…
-
Exporting/Sharing Filtered and Indented Sheet View
I'm looking to find a way to share a filtered view of a project with a supplier. I would like to either share a live view or schedule sending an updated version of the project plan weekly. The issue I'm running into is that there doesn't seem to be a way to to do this in a way that the rows are both filtered and indented.…