Pulling just the date from a cell

amy_ilearning

Hi! I think my question is pretty simple. On a sheet, I have two columns. One is "Primary", and it's blank. The other is "Created" - a date/time column that auto-populates from a form. I want the primary cell to only pull the date from the Created column. I've tried a few different formulas with no luck. Anyone have any suggestions?

MD Simpson

I'm currently using the formula =LEFT(CREATED@row, 8) to pull this from the Created date field. Make sure your column type is still set to Date even when using the formula.

Andrée Starå

https://community.smartsheet.com/discussion/128477/pulling-just-the-date-from-a-cell

Hi,

I hope you're well and safe!

You would use the DATEONLY function.

https://help.smartsheet.com/function/dateonly

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

amy_ilearning

Hi! I tried the formula =DATEONLY([Created]@row) but it's showing Invalid Column Value. Not sure what I'm doing wrong…

Andrée Starå

https://community.smartsheet.com/discussion/comment/446454#Comment_446454

Ensure that the column is set to Date.

Did that work?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Paul Newcome

If you are dropping the formula into THE Primary Column, you would need to convert the output into a text value by "adding quote quote" to the end.

=DATEONLY(Created@row) + ""

Andrée Starå

https://community.smartsheet.com/discussion/comment/446485#Comment_446485

Good catch! I missed it was in the Primary Column.