-
Is there a way around the row limitation on report widgets within a dashboard?
Hello, I have a dashboard which shows a summary of key information from a sheet that outlines purchasing history of our company. It pulls from a report that summarizes information from the main sheet as a widget on the dashboard, and allows viewers to scroll down through the history of purchases line-by-line should they…
-
How to create a dashboard from a client smartsheet project
We are working on a system conversion. The project is in Smartsheet but owned by the new system company. They've not been able to provide the level of reporting my SLT is requesting. How can I create a dashboard from that project without doing any changes or calculations, summaries within their project? They did make me an…
-
Survey Reporting
I have created a survey and activated a form which is now being completed. The data is coming back into the sheet, but now I need to report on that data and hopefully build a dashboard for all of it. How can I report on qualitative information? The choices are correct or incorrect for each of 25 questions across maybe 80…
-
Auto-update column names in reports
Reports should auto-update when column names are changed. Currently, renaming a column in a sheet will corrupt any reports that reference that sheet column. Reports should reference the backend column ID and not the column alias in the UI.
-
Past Due Date in Business Day Formula
Hi! I have a formula I have been trying to figure out. I'm getting stuck because I want to make sure that the duration does not include weekends or holidays (if possible) and there is a condition. Any help would be appreciated. I would like to know how many business days past due a project is from today, but only if…
-
How to duplicate multiple reports at once and rename into another folder
I have over 20 reports for each dashboard to duplicate into another workspace folder. I have 6 new dashboards to duplicate and 20 reports for each dashboard. currently, I have to open each report, rename and save to a new folder. How can this be more automated? I looked at Control Center and not sure I see that being a…
-
Smartsheet users in The Netherlands
Hello, We're using Smartsheet in our R&D department to manage product development. In order for us to make a next step in using Smartsheet functionality and building more complex dashboards, we are looking for Smartsheet users in The Netherlands or Benelux. Please reach out to me if you are or know someone. Thanks, Rob
-
Report as a web content widget?
I'm looking to make a report available as a web content widget. However, the only option when publishing the report is "Read Only". I need this report to be interactive right on the dashboard. Is there any other way to accomplish this? A report widget does not allow me to edit the report content on the dashboard.
-
Can I increase the font size in report on my dashboard
I have a sheet that is font size 10 and that is readable on my computer. I created a report and put it on a dashboard, but the font size seems smaller than the size 10. How can I increase the font size on my report/dashboard without increasing the base sheet font size?
-
Report filter mystery
Hi all, In my projects, I have a column Project Phase which generates numbers in this format: 04.3 In a report, I want to display all tasks that are part of Project Phase 04.3, but I am having trouble getting this to show up on reports. Filters that do not work: "Project Phase - is equal to - 04.3" "Project Phase - is one…