AUTO DATE COLUMN UPDATING WHEN OWNER LOGS IN

Options
Fialko66
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 ✓
    Options

    @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

    LinkedIn

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

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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

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

Answers