Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Rows being removed

Teresa Meyer
edited 12/09/19 in Archived 2015 Posts

I just realized that a user removed a row from the smartsheet.  So I have 2 questions. 

 

#1 - Can I keep people from being able to remove a row - while still allowing them to edit information?  or

 

#2 Can I set up a notification when a row is removed - so at least I would know when it happened.

 

Any suggestions?

«1345

Comments

  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭

    You can lock the row.  As long as the user is an editor or viewer they can not delete or alter the row.  Please note that any Admin user will be able to modify or delete the row.

     

     

  • But if they need to edit data - will the row lock prevent the data from being edited?

  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭

    Yes.  You're right they will not be able to edit the row. 

    Just tell them to be careful!  Only kidding.Smile

  • Travis
    Travis Employee

    You could send an update request to the user. They can view and edit only the rows you send and will not be able to delete the row. Here’s information on update requests: http://help.smartsheet.com/customer/portal/articles/504779-using-update-requests

     

     

    You might also consider backing up your data in case users accidentally deletes data in the future: http://help.smartsheet.com/customer/portal/articles/506499-backing-up-your-data

  • If I have set up an alert to receive an email if anything changes, will I be contacted if a row has been deleted/removed? 

     

    Will I be able to see what was removed aswell?

     

    How do the large companies with thousands of collaborators deal with this issue?

     

    Thanks,

    David

  • Travis
    Travis Employee

    Hi David, yes you will get an email when rows are deleted but the email does not tell you which row was deleted.

     

    There may be Community members who could offer suggestions for how their businesses handle deleted content. 

  • Thank you Travis, I'll look into it.

     

    Any reason why this is not a feature?

     

    Thanks,

    David

  • Travis
    Travis Employee

    David, here is my personal opinion from a user perspective...

     

    Row order can be changed on sheets through sorting or rearranging rows. Giving the row number of deleted rows could help tell you the section of a deleted row if row order was not changed but it could also lead to confusion about where the row came from if row order was changed.

     

    Showing the full rows that were deleted could be useful if there are a small number of deleted rows but what if a user deleted 1000 rows? Should the email contain all 1000 rows?

     

    Our Product team is always looking for user input on system enhancements. If you would like to give me your opinion on how you would like this to work, I would be happy to submit your suggestions to our Product team to assist them with future development scoping. 

     

    Thanks! 

  • Hi, I'm also looking for a solution to capture any unwanted deletions: if a sheet is shared with many users, and some user (accidentally) deletes a row, I would like to be able to see it (actively with a notification or passively by monitoring some log) and to be able to recover it. I can use the notifications feature to see if rows are deleted, but I would also like to see what rows are deleted. Of course I will tell people not to delete anything, but with many people involved there is always a chance it happens. Thanks.

  • Travis
    Travis Employee

    Floris, we are exploring adding an activity feed which can give you more detailed information about the changes made on your sheets. I don’t have specifics about how this may work but I think it will likely solve some of the issues you mentioned. I will pass your feedback along to the team working on this. 

  • This seems to be a common concern/question.  We'd like to be able to allow editing ability but prevent anyone from deleting a row in full.  Or, if a row or sheet was deleted, how can we know what was deleted or recover it?

  • Travis
    Travis Employee

     

    Hi Chris, I will submit your suggestion of preventing editors from deleting rows, to our enhancement request list. Thanks for posting!  

  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭

    I have the same concern. I like Cell history feature very much, because I can see any changes to any cells in a sheet, whith names and dates. I would also like to see some kind of "Sheet history" with major changes to the sheet itself. For me (and for many others, as we can see in this discussion) deleting a row is a major change to a sheet. Usual back-ups AND notifications when rows are deleted may be a solution, too. 

  • I'm hoping the comapny is reading these, because this will probably stop us from going forward with this product.

     

    We NEED users to be able to udate their status (Completed, Flags etc) as they could be anywhere in the country or world, without them having the ability to Delete OR Add a row when a column is locked on that row.  I don't want to have to constantly check if someone has made such a change or receive emails about changes.  Shouldn't be allowed.

This discussion has been closed.