Modified (date/time) changes for no reason
I have a mechanism where when a row updates in an intake sheet it copies that row into a master sheet. I also have a column that denotes, if the new imported row has certain cells the same as a pre-existing row (i.e. a duplicate row) it will move the old row and only keep the new one. Doing this since Smartsheet automation can only move and copy but not replace, which is ultimately what I need.
Problem I'm having, is in the master sheet the Modified (date/time) column of the old rows will update when the new row is imported in. Which prevents my mechanism from working to move out the old rows, only keeping the most recent one. I can't figure out why. I checked the Activity Log and the only cell changes made to those old rows is the Modified column. So I can't figure out why it's doing that.
Help Article Resources
Check out the Formula Handbook template!