How do I create a formula to pull the year from a date from every row in a column?

Hello! I am very new to formulas, and I'm having a hard time figuring them out. I want to create an automatic function that will pull the year (and separately, the month) into a new cell, so that I can break down my sheet into year, and then month, with collapsible rows.

Basically, I have a row titled "Date of Employee Request". I need a formula to pull the year from every row in this column into a new column titled "Year" and to automatically keep pulling it as new rows are added. I'm certain this can be done, but all my attempts to make it work have failed.

I appreciate any help or insight.

Thank you! 😊



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!