I am seeing a few rows that were deleted months ago show up in a report. Since they're "not there" in the source sheet, there's no way for me to remove them!
Has anyone else had the same trouble? Did you find a solution if so?
This may seem like an obvious question, but have you checked if there is a filter applied on the source sheet that is blocking you from seeing the row you believe is deleted?
If indeed the rows are really gone, is it possible that the report is referencing more than one source sheet, and the "deleted" rows are present on that other sheet?
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Thanks, Jeff! The report was also referencing the rows in the archive sheet that keeps the completed items from the original sheet. I'd referenced the archive sheet to check how completed tasks might display, and then neglected to remove it. Whew!
I celebrated too soon. The deleted rows are still showing up, even after removing the archive sheet reference.
I'm not sure how to re-open this, so I may need to re-post?
@mdcatlett I'm assuming you've closed and reopened the report, and verified there are no other sheets being referenced in the report? You may need to add the "Sheets" column back into the report to check for sure.
What happens if you do a Smartsheet global search for a unique value from one of these "deleted" rows?
Closed, reopened, verified a single sheet source, cleared my cache and cookies. The global search for a string unique to the row turned up nothing.
I just now added a column to the source sheet, and the unwanted deleted row vanished from the report. 🤷♀️
I think I'm going to wait a day or so to see what develops, because I believe it may have disappeared and reappeared earlier today.
Thanks for sticking with me, Jeff...!
I'm encountering the same issue.
I'd copied a previous 800 lines schedule to a new name and deleted 700 lines, saved, created report of tasks count (line items) and it still showed 800 lines.
Deleting lines --> selected the lines, right mouse and select 'delete'
Thanks in advance.
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…
39 submissions isn't accurate because many of them were just tests. Currently have 3 submissions and would like for it to show 3, is that possible
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.