How to remove BLANK values in Pivot sheet. The source sheet is having a default rows, but I am maintaining limited rows and rest of the blank rows are reflecting in Pivot sheet. How do I remove ?
You can hide the column in your destination Pivot sheet or create a Report from this sheet that filters out both the row and the column.
Hiding columns will only remove some blanks. There doesn't seem to be a good way to remove them from the rows. A report will do that, but it will not keep indents...
Noted, i observed this Pivot tool is not efficient as conventional pivots in excel. I used REPORT to sum-up these fields.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.