-
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…
-
Create groups of widgets on dashboards
It would be very helpful for us if we could create "groups" of widgets on dashboards, and allow actions to be taken on a group. I'm thinking this would be similar to how grouping works in the microsoft projects. First you select all the widgets you want in the group, then you select an option to group them. Our primary use…
-
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…
-
Automate dashboard?
Dear SmartSheet Community, I hope this message finds you well. I'm reaching out to inquire about SmartSheet's capabilities for automating the creation of weekly and monthly reports. Our objective is to streamline our workflow by eliminating the need for manual report generation. We are particularly interested in:…
-
DASHBOARD SORT ON MOBILE??
Am I correct that there's no way to sort dashboards on mobile? I need things sorted by "end date" so I can quickly see what is coming due out of glance on my phone. If not a feature, that is very unfortunate since I was willing to pay for this product. If this feature is available I will buy this product - can someone…
-
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
-
How to create a starting next/ending next box on the dashboard?
I am looking at a template from smartsheets, and I liked that they had a starting next and ending next box on the dashboard. Would I be able to set this up with tasks in a row in a sheet? If so, how can I set this up?
-
Average number of day formula
I have these two columns "Date Created" and "Date Closed". I need to write a formula that looks at all 1000+ rows of data and produces an average amount of days it takes to close a row of data. The formula will be in my calculations sheet. So, I'll be referencing this data. Should I use the "averageifs"? I really…
-
OneDrive Dashboard Shortcut - Link Options
Please add the ability to modify OneDrive links. Right now you select a file but there are no options about what type of link is being used for the shortcut. It would be nice to have access to the OneDrive Sharing Settings so you could choose who the link is available to and whether it is Edit or View Only. Thanks
-
links to pivot sheet cells do not hold the link
I have created a pivot sheet. I then from another sheet link a cell to the pivot sheet but the link does not hold. This just started happening with newly created pivot sheets. I have a number of older pivot sheet created and the cell links are fine. I also use pivot cell links in my dashboard metrics, they are now coming…