I've searched multiple questions on how to calculated years from start date.


I've tried multiple calculations and all I want is to calculate the years of service. I can use the conditional formatting to note milestones 5, 10, 15, years etc. I did confirm the Start Date field is formatted as a date and getting #INVALID DATA TYPE.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!