-
Is there a way to create 2 Reports from one Sheet with different formatting?
I am looking to create 2 Reports from one Sheet that contains employee time off requests. The Sheet contains 13 columns, but for simplicity, the relevant fields are as follows: Employee Name Division Start Date End Date PTO Used (# of hours) Approved? I would like to have one report for the managers to show Name, Division,…
-
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…
-
Multiple Filters In Reports that Collaborators can Choose/Select
I want to be able to develop 1 master log and create reports and forms for employees to use to change or add data. In order to change filters, I believe you need more permissions than an editor. To follow through with my idea, the editors would need to be able to change the filters. What if we had the option to lock or…