AUTO DATE COLUMN UPDATING WHEN OWNER LOGS IN
hey, I'm fairly new to Smartsheet so assuming I've done something wrong when setting up a date column to automatically update the date when anything in the row is amended. I set the column up as Modified Date but if i click on any row as Owner it changes the date in every row to the date/time i clicked on a row (even if i make no changes). This negates the use of the column which was to ensure nothing went over 30 days without updating unless i don't log in. I have checked this with and admin of the sheet and it doesn't update all of the dates when she logs in. Can anyone advise please?