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

Options
Christopher Neal
Christopher Neal ✭✭✭
edited 07/29/21 in Formulas and Functions
Screenshot 2021-07-29 3.18.17 PM.png

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

Tags:

Best Answer

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭✭
    Answer ✓

    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.

    image.png






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

    image.png







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

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    Cheers,

    Brett Wyrick | Connect with me on LonkedIn

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!