-
Text size on dashboard
I created a dashboard with the intention saving it to a PDF. However, the font in the body of the reports that I included on the dashboard is very small (I think 10 pt). Is there a way to change the font for the body of the report on the dashboard? I am able to change the font when I go to the report, but that does not…
-
Sorting in Report
I am trying to create a dashboard widget to show Risks in order (High, Medium, Low) but in the report, it does not let me sort it that order. I tried to create a helper column in the underlying sheet using 1 for High, 2 for Medium, and 3 for Low however even when I group, sort, or summary count off these, I am unable to…
-
Renaming Column Name in Report
1) Is it possible to change the Name of Column in Report instead of Source Sheet. 2) Auto Columns name is appearing in the Report instead of Column Name (Ex. Created by , Modified By, Created Date and Modified Date). Is there any way to change System Columns name in the Report. Thanks for your support. Best regards.
-
Required advice on creating a view on Overdue tasks
Hi, Smartsheet champions. Does anybody have ideas on creating a view like below (or similar) on Overdue tasks? Perhaps creating a column in tasks sheet with formulas to calculate the Days Ago number and pulling a report will work?
-
Unable to Access Large Sheets But Data Still Accessible
I've been having an issue the last couple of weeks with two very large sheets. One is automatically updated via Data Shuttle and the other has rows pushed to it weekly. I can't open them directly but I know they are still functional because I can still move rows to them, other sheets can access the data via formulas, and I…
-
How to access all columns in a Report when creating a Dashboard Chart?
Hello! I have a report that is summarizing project costs, sorted first by the line-item code in the budget and then by Quarter of Completion afterword. I am hoping to represent this data graphically with a dashboard chart. The goal is to have a Bar Graph that shows the cost in each quarter, clustered by the budget item.…
-
What is the maximum row count for a report (I know there is up to 2,500 rows per page)
-
Build Report that Pulls Row and Summary Sheet Data
We are currently only able to build reports sourcing from EITHER row data or Sheet Summary data. The request here is to have an option to source from both.
-
Sharing reports with free users --- updated question
I had asked this question previously and thank @Shanky Paul for answering! I'm still trying to figure out if I give them access to the source sheet, will they be able to see the source sheet and if so, then why would I create a report? There is a column in the source sheet I don't want to share. Thank you!…
-
Formula to lookup a value based on start and end date
Hi All, I need your support on this case. I have a project to improve the current sales report layout and I need to extract the Vendor Support data for each item depend on the sales records, and the start and end date for this vendor support. Here is an example: Below is the table where I want to have the formula to…
