Formula @Row Question

Brooke Jackson

I am trying to edit a formula for our naming convention column in SS. The below is our current formula. At the end it pulls in the year according to today's date. Instead we want to remove that and have it pull in a date (just the year) from our "Final Due Date" column. How would I edit the formula to pull that in? We don't want the full due date pulled in, just the year.

thanks!!

heyjay

+ Year([Final Due Date]@row)

Paul Newcome

I would use

RIGHT(YEAR([Final Due Date]@row), 2)