Different Dates on the one sheet
I am in Victoria, Australia and I am using a form to populate a sheet. I want to automatically populate the Inspection Date to be the date the row was created. I am using the formula =created@row
The Created date, being the system generated date is correct, but as you can see the Inspection date using the above formula is the wrong date - depending on the time of day it was entered. How do I get the inspection date to be the created date?
Answers
-
Hi @AmandaHore,
I wonder if this is related to issues I have had with Date formats and different times showing. I'm in Adelaide and occasionally have cells displaying dates in US format, which also take on the Pacific Time zone.
So I can have a change made on a Tuesday, but then cell links, formulas, and automations take place and attribute the change to late Monday.
Here's the details from my support ticket
'While it is not ideal, this is expected behavior when cell linking system columns "Created date" and "Modified date". This is documented in the help article: Troubleshooting:How Smartsheet handles time zones.
You may want to submit an enhancement request via our community page for consideration by the product team.'
Best of luck
Paul Reeves. MBA, LSSBB
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives