How to create a formula that logs the date the row was created

Alicia D

I need help coming up with a formula that enters the date in the date column any time an entry is made/ new line created. I tried the =(today) as a column formula, but every day it just updates all of the dates to be whatever day it is, and not the date that the row was created.

Gillian C

Hi @Alicia D

There are a couple of ways you can do this.

You can utilize the smartsheet column properties 'Created date'

Or if you can't use this then you could add an automation

Just select a column that will be populated when the row is added where 'Primary Column' is noted above and the column that you record a date in would be whatever date column you want that recorded in.

Hope that helps