-
Dashboard - Report Column Widths look ridiculous
I have a report that feeds into a dashboard with 8 columns: * At Risk (flag column) * Health * Task Name * Assigned to * Status * Progress Bar * Start Date * End Date Why does it stretch that last column (end date) so wide? It looks ridiculous. The At Risk flag columns is a very appropriate size for the content. So it the…
-
Print Scaling Inconsistent
I have 2 separate reports. The first report is 44 rows in length. From smartsheets, when I print the report and use the Fit to Width function, the report is 1 page wide by 1 page long. This report has 16 detail columns. The second report is 37 rows in length. When I print and use the Fit to Width function, the report is 1…
-
INDEX, MATCH, AND formula
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW item types. The formula entered on Sheet Two is: =IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0), MATCH("NEW", {SHEET ONE_ITEM…
-
Gantt chart representation on Dashboards
I know how to make a report so that I can show a timeline in a dashboard. The strange thing is that the Gantt chart does not show dependencies or % complete, even if I include those columns. Is this something that should work currently or something that has not yet been implmented? Also, "Dashboards" does not appear to be…
-
Smartsheet down in certain area's ?
Dears, Writing on the community as I am not getting any feedback on the support tickets. Our Malaysian department (both our co-workers + local customer) is logging in but not able to work as the sheets are not loading - see screenshot. Systems have been rebooted / logged out and in again and local IT checked - our end is…
-
SOLVED: Missing Report Builder button
In the Reporting module in the Smartsheet e-Academy, it indicates there should be a Report Builder button in a report to enable one to modify the report. In my instance I do not see such a button. Is this a known issue? I've attached screenshots of what it's supposed to look like, and what it actually looks like. I could…
-
Idea on connecting two Smartsheets?
I have two sheet that i want to reference and update each other. They both follow similar formatting, with one being more of a log/reference for the other. I would like one list to dynamically update the other. How would i do this? Items list - I have a items list that will show an overview of purchase orders to be done…
-
Reference a date based on Percentage complete
In Sheet One, there are 25 products assigned to 4 Product Types. Each Product has an expected delivery and an actual delivery date. In Sheet Two, we want to add the dates associated with the percentage complete. The existing formulas provide the percentages and totals but how can I add the dates for the milestones. For…
-
How to include parent rows in reports?
Is this possible? Saw a workaround (https://www.smartsheet.com/blog/smartsheet-tips-displaying-parent-rows-reports) but is there an easier way? I see an example it in the Sights Gallery - Sales Pipeline as well
