Modified by cell-link@smartsheet.com

Sreeranjith Premsekar

Sometimes "Modified by" is captured as cell-link@smartsheet.com ?? we are having formula columns based on modified by column, if randomly smartsheet captures it as cell-link@smartsheet.com, all the calculations are going wrong,...pls advise.

Paul Newcome

This will happen if a cell that is linked in from another sheet is updated. Do you have any cell links or cross sheet references in your sheet?

Sreeranjith Premsekar

Hi @Paul Newcome thanks for the response, yes we maintain the user's timezone in another sheet where we calculate GMT based on Modified user timezone. By I don't have cell link in "Modified By" cell, but I have it in other cells. Let me know how can I prevent this happening.

Thanks.

Paul Newcome

You won't be able to prevent it. The "Modified By" cell captures date/time for any change in any column for that particular row, and you cannot exclude columns from this.

One option would be to set up a "Record A Date" automation and set the trigger to be based on any of the columns that are not cell linked in, but that will not provide a time stamp.

Sreeranjith Premsekar

Thanks Paul, "Modified By" is the user name captured immediately after the row updated and the column is managed by smartsheet. I have references to other sheets in a different column. I am not sure why smartsheet captures cell-link in "Modified by" column.

Paul Newcome

Because the cell link is modifying the row. The "Modified By" cell captures date/time for ANY change in any column for that particular row, and you cannot exclude columns from this.

Marion Dubois

I'm having the same issue.

I was hoping to use the Modified by to spot when a team member had updated a tracker. I made a vlookup to a different sheet to bring other info and I now am faced with a very useless Modified by.

Such a shame that cell-link cannot be excluded as the positives of moving the a Smartsheet grid are somewhat watered down.