How can I manage the integrated spreadsheet?

  • Profile Image
    taktse
    Asked on April 23, 2015 at 12:55 AM

    I am having trouble managing the integrated spreadsheet because whenever I add a comment, the person whom the spreadsheet is shared with automatically deletes the comments. I have tried changing the shared person, and also re downloaded the spreadsheet but the problem continues. 

    Please suggest how I can avoid this from happening without losing any data.

     

     

  • Profile Image
    Welvin
    Answered on April 23, 2015 at 09:06 AM

    Hi,

    Did you mean to say that whenever a new submission is added to the spreadsheet, this new submission will automatically delete your comments? As if the spreadsheet will revert back to its default state? If yes, I think that's how our integration works right now. It keeps the original spreadsheet to avoid any problems that might occur when changes are made to it. In this case, we recommend using ImportRange function in the spreadsheet. You have to process the data into another sheet so to keep the original intact.

    https://support.google.com/docs/answer/3093340?hl=en

     

    Or did you mean to say that your colleague deletes the comments and you want to stop them from doing so? If yes, you can change their permission to just view.

    https://support.google.com/drive/answer/2494886?hl=en 

    If none of these answers your question, then please clarify.

    Thanks