-
Report not pulling info from sheet #2
Hello, I am trying to pull the column Tech Level into a report that is pulling from 2 sheets. The report is pulling correctly from sheet1, but I can't get it to pull the tech level column from sheet 2.
-
Dashboard Update Automatically Daily
Hello, I'm having issues with a dashboard I have set up, not updating information from a sheet until that sheet is opened/refreshed. I currently have a sheet with rows of names and corresponding dates; basically, shift schedules by day. I then pull whatever names correspond to today's date into a sheet summary and have a…
-
Problem with Multi-sheet Report interpreting identical columns as unique
I am having difficulty with not understanding how to force SmartSheet row reports to understand that a particular column I have on multiple sheets is indeed the same thing, and I want it displayed on the report as a single column. It somehow does this automatically and sometimes correctly identifies this, other times not.…
-
Sheet Summary Report and Dashboard Widgets
Hi! Can I use a Sheet Summary Report to drive a Metric widget? I have 25 project sheets that I would like to roll-up into a sheet summary report. I would then like to create dashboard metric widgets using this data. I am currently driving the metric widgets off of the individual sheets, but this is getting cumbersome as we…
-
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…