Fialko66 ✭✭
edited 06/15/22 in Smartsheet Basics

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?

Best Answers

  • Sing C
    Sing C ✭✭✭✭✭✭
    Answer ✓

    @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!

    Sing Chen

    Process Architect, Ceridian


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓



    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!


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

    W: | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.