-
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…
-
SmartSheet Dashboard: Enter a value, have data autofill
Is there a way to build a SmartSheet Dashboard, and have a field that we can enter a value (say a project #) and have the corresponding fields autofill/populate as a result of that action? Or have a dropdown that autofills with all of the project #'s, we select one and then the corresponding fields populate from that…
-
Weekly date with manual override
I'm looking to create a formula to have a cell show a date for when our next delivery comes in. Typically these deliveries are every Tuesday, but sometimes they are late by 1 day, or we skip a week because we don't need it. I would like a cell to show the next estimated delivery date example. Today the cell would show:…
