Modified by cell-link@smartsheet.com
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.
Answers
-
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?
-
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.
-
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.
-
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.
-
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.
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!