AUTO DATE COLUMN UPDATING WHEN OWNER LOGS IN

Fialko66

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?

Sing C

@Fialko66 I can't say I've seen that behavior before. I just tested it by adding a system column in a test sheet I created and when I entered 'test' in the Primary Column and saved the sheet, it populated the modified date.

I subsequently started clicking in different fields in the sheet over the next few minutes and didn't see the Modified date column getting updated.

Have you looked at creating an automation to set a non-system date column? The 'Change Date' column you see in the screenshot is a date column and I created this workflow:

I then entered data into "New Col" column of my sheet and the "Change Date" column was updated by the automation.

Let me know if that helps!

Andrée Starå

@Fialko66

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Do you have any formulas using the TODAY function?

Fialko66

No formula used. I've set column properties to auto-number then modified date and it only does this for me as owner!

Sing C

@Fialko66 I can't say I've seen that behavior before. I just tested it by adding a system column in a test sheet I created and when I entered 'test' in the Primary Column and saved the sheet, it populated the modified date.

I subsequently started clicking in different fields in the sheet over the next few minutes and didn't see the Modified date column getting updated.

Have you looked at creating an automation to set a non-system date column? The 'Change Date' column you see in the screenshot is a date column and I created this workflow:

I then entered data into "New Col" column of my sheet and the "Change Date" column was updated by the automation.

Let me know if that helps!

Andrée Starå

Hi @Fialko66

I hope you're well and safe!

Are you using any column formulas?

Can you share a screenshot of how it looks?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Fialko66

Hi and thanks to everyone for helping. I changed the auto date column to a normal date column and set the automation detailed above and this works now.

Thanks you again

Andrée Starå

@Fialko66

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!