When a row is created, how can I tell one of the columns to add today's date...

MarkSchlaudraff

So I'm using Unito.io to pull data from DevOps, and I need to know when the row was created ( Not Updated ) in smartsheets.

So, I looked at using the "auto number," but there is no way to tell it to use the date.

Can someone help?

DKazatsky

@MarkSchlaudraff One of the column types is "Created Date" - that should be exactly what you are you looking for.

Andrée Starå

Hi @MarkSchlaudraff

I hope you're well and safe!

You could use a Workflow combined with the record a date Action.

Another option could be to add the system column, Created Date, and then get the date and time the row was added to the sheet.

Would that work/help?

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

MarkSchlaudraff

I think I found the solution, which is to make a automation that adds the date in a select column when a row is created.

Andrée Starå

@MarkSchlaudraff

Excellent!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bella_Love

I am trying to do the same thing in Smartsheet but I do not know the formula for this. Can someone help?

KPH

Hi @Bella_Love

No formula needed for either of these suggestions. I realized this is very similar to your other question which is slightly longer so have grouped my replies. Please see the comment on your other post: https://community.smartsheet.com/discussion/119831/please-share-the-formula-to-capture-creation-date-for-rows-in-smartsheet#latest