-
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…
-
Customize the one click down for Card View or Gantt View in Reports
When you double click into a card/ gantt line, would love the ability to only show a sub selection of whatever columns were picked in the report vs someone having access to all that's available from the original sheet. Currently when we create reports, we love the clean view of only a few data points in a card view or…
-
Merged: Card View of Reports to only show columns selected for the Report
This discussion has been merged.
-
Have embedded report show collapsed by default on dashboard
Hello, I have a report that makes use of the new grouping functionality. I have it embedded on a dashboard (since use of the filters and grouping is not quite ready for prime time with the report app). Even if I collapse all of the groupings in the report before saving, it still renders as completely expanded when embedded…
-
Grouping issue in a report
Hi all, I have a report that includes tasks (primary) and assigned resource (person, using contact list) pulling from about 70 sheets - all with identical columns. When I group by the assigned resource, the report it's still splitting a several of the same resources into two different groups. I've double checked there…
-
Weekly completion running report
Hello, I am trying to create a report for our operations teams to track how many assignments they complete from M-F & then have the report reset on the following Monday. I had previously set up their metrics report using the "In the last _ days" filter, but that is inadequate for them since they want to see their weekly…
-
Grouping without sorting by that grouping?
I have a row report that I need grouped by one column and sorted by a different column. The grouped column is sorted as text and is showing 1, 10, 11, 12...2, 20,21... The column that I want to sort on is sorted as a number which is correct. Any ideas on how to break what SmartSheets has built in?
-
Data Over Time Report/Dashboard
Hello, What steps should I take in creating a dashboard that includes a graph displaying data over time? I would love to be able to click on each data point and a pop up of that data point displays information during that time period. Here is an example of something I would like to create in Smartsheets
-
Smartsheet to SQL Server
Hi Team, Just curious Is it possible to link Smartsheet to SQL Server to fetch data?Thanks
-
How to summarize data from multiple sheets without manually linking each cell?
Hello, I'm working on a project with KPIs that will be entered into ~50 individual sheets. I want to be able to roll-up these KPIs into one summary view, but am running into trouble when I pull them into a report because I can't perform calculations in a report. One KPI is Overtime %, so I can't just take the average of…
