-
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…
-
Can I link an entire sheet into my master sheet?
It looks like I need more than Cell Linking in our master project tracker. Do we have the ability to add a section on our master sheet so that any updates from a separate MARKETING TEAM sheet is displayed in the master sheet? I'm afraid simple cell linking only focuses on cells and won't take into account additional rows…
-
Line Limit on Dashboard Report
I'm inserting a custom report into a dashboard, but it's only showing the first 150 lines. After that I have to "click to view source report". But no matter how much 'sharing' I do, I cannot enable a non-Smartsheet user to be able to see the whole report. Is there a way to have the entire report scrollable on the…