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?
Best Answers
-
@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!
-
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
-
Do you have any formulas using the TODAY function?
-
No formula used. I've set column properties to auto-number then modified date and it only does this for me as owner!
-
@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!
-
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!
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.
-
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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 151 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives