Can I only show the year from the date in another column

Christopher Neal

I just want the year from [Completed Date] but not able to figure it out.

Brett Wyrick

https://community.smartsheet.com/discussion/comment/299562#Comment_299562

Hey Chris, that's because the column you're utilizing for inputting in the YEAR() function is a "Date" type column. When you're inputting just a year, say "1999", it invalidates the column's rule of showing a "Date" value.

You'll need to change the column type to "Text/Number", and the =YEAR([Completed Date]@row) function will work.

My "Completed Year" column is a "Text/Number" type column, which gets the below value:

If this completes your question, please mark "Yes" below - it helps others find this solution (and Google searches!)

Mark Safran

Hi @Christopher Neal,

The YEAR( ) function does exactly that:

=YEAR([Completed Date]@row)

-MS

Christopher Neal

Yeah that's what I was thinking too but I keep getting this error below.

Brett Wyrick

https://community.smartsheet.com/discussion/comment/299562#Comment_299562

Hey Chris, that's because the column you're utilizing for inputting in the YEAR() function is a "Date" type column. When you're inputting just a year, say "1999", it invalidates the column's rule of showing a "Date" value.

You'll need to change the column type to "Text/Number", and the =YEAR([Completed Date]@row) function will work.

My "Completed Year" column is a "Text/Number" type column, which gets the below value:

If this completes your question, please mark "Yes" below - it helps others find this solution (and Google searches!)

Andrée Starå

Hi @Christopher Neal

I hope you're well and safe!

To add to Mark's excellent advice/answer.

You can't use the YEAR function in a date column if you don't add +"" at the end.

So you can either change the column type or use the +"" at the end of the formula.

Something like this.

=YEAR([Completed Date]@row) + ""

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

Christopher Neal

https://community.smartsheet.com/discussion/comment/299567#Comment_299567

Thanks!

I should have known!

Have a great day

Brett Wyrick

@Andrée Starå Nice! I didn't know about the ' + "" ' at the end of a formula for it to work on a Date column. I learned something today.

Andrée Starå

@Brett Wyrick

Excellent!

Glad it was helpful, and apologies for missing to reference you in my answer. I missed your answer.

Pro-tip. It also works in checkbox columns (and probably others as well). It converts the formula result, so it's interpreted as text.