For some reason a report is bring in rows I did not select. I went back to the sheets and could find anything, so I deleted the content on those cells but the rows are still showing up on the report. How can I remove the blank rows of my report?
Hi @Silvana Luna
I hope you're well and safe!
You'd either need to delete the specific rows in the sheet(s) or update the Report Builder not to include them.
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
How long did you wait after saving the sheet?
I don’t know how the data is consolidated for the report, but I have noticed a delay is changes from the sheet getting propagated to the report.
Otherwise, have you made sure all filters are removed? And are you pulling from more than one sheet?
@Andrée Starå Thank you. I did not use Report Builder to build this report. This report was built using multiple sheets. I looked at the cell history of the report and identified the sheet with the issue. I went back to the sheet that had the issue, deleted the row and updated the report, but that row was still showing on my report. I don't have a way to remove that row from my report. Any other ideas?
@James Keuning @Andrée Starå Thank you. I hit the refresh button several times. This report was built using multiple sheets. I looked at the cell history of the report and identified the sheet with the issue. I went back to the sheet that had the issue, deleted the row and updated the report, but that row was still showing on my report. I don't have a way to remove that row from my report. Any other ideas?
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
we are looking to migrate out of smartsheet and are needing to export all of our sheets out and store them in onedrive. what is the best way to preform this?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.