-
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
-
Disable auto refresh?
I want to make a dashboard that pulls data from another sheet, but I only want to update it once a week. Is there any way to delay the auto refresh?
-
Consolidating Data from Multiple Sheets
Hello, I'm hoping there's an easy way to do this. I have three sheets, they all are filled in using forms. All three sheets are used for tracking things to be billed to the same list of clients. This client list is identical between all three sheets, if it matters. I'd like a single sheet I can look at each month that will…
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
