Activity Log | Rows Deleted Filter

Options
Jake Gustafson
Jake Gustafson ✭✭✭✭✭✭

I've got a conundrum on my hands where a record has gone missing. In the Activity Log, I'm able to find the record of when it was created. However, there is nothing I'm seeing indicating that it was deleted (even though the Activity Log doesn't have a specific filter for this, I traced through the log for the past 11 days since the record was created and found nothing). I'm curious if others have other ways to find lost records or deleted records (my assumption is this got inadvertently deleted, but without Activity Log proof, I cannot be certain).

Other info. When all things are 'done' on one of these records, then an automation moves the row to an archive sheet. The record is not found there either, nor does the Activity Log show signs of it existing or being deleted from there. Based on the info provided by my colleagues, it should have never been eligible to move sheets as there is still work to be done with it, that's why they're curious as to where it is now.

I submitted a Product Enhancement Request for a 'Deleted Rows' filter in the Activity Log to avoid having to scroll through the thing looking for the 'Deleted' phrase and expand the item.

Looking for anything I might be overlooking or that you've done to solve a mystery like this in your past Smartsheet experiences.


Tags:

Best Answer

  • Jake Gustafson
    Jake Gustafson ✭✭✭✭✭✭
    Answer ✓
    Options

    Ok, I found it. Classic case of submit something for help, then find the answer. I think what may have happened previously, is that I turned on all the filters, but since there isn't one for a Deleted Row, maybe the Deleted Row was hidden. When I came back, I didn't click anything on the filters for the Activity Log and when scrolling through looking for the 'magic' delete word, I found the record I was looking for.

Answers

  • Jake Gustafson
    Jake Gustafson ✭✭✭✭✭✭
    Options

    I also know this much:

    • The record was created on 7/31/23 at 2:19 PM
    • I get an Excel extract of the sheet on Sundays at 5:00 PM and it was not present in the 8/6/23 file.
    • So, something happened to the record between 2:20 PM 7/31/23 and 5:00 PM 8/6/23.
  • Jake Gustafson
    Jake Gustafson ✭✭✭✭✭✭
    Answer ✓
    Options

    Ok, I found it. Classic case of submit something for help, then find the answer. I think what may have happened previously, is that I turned on all the filters, but since there isn't one for a Deleted Row, maybe the Deleted Row was hidden. When I came back, I didn't click anything on the filters for the Activity Log and when scrolling through looking for the 'magic' delete word, I found the record I was looking for.