Different Dates on the one sheet

AmandaHore

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?

PM_Reeves

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