Dates to populate values in associated cells


I'm working on a training sheet where every year you work its worth a certain amount of points. What I would like to achieve is after the date (1) is repeated annually, the "Years Served" (2) column adds +1. As this is done the "Year" column (3) is updated to a certain value of points based off of "Years Served"

I believe all of this can be done in automation but after trying countless times I'm failing to achieve this. Any help would be greatly appreciated.

(Attached is the example of the sheet I am using)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!