Use a YEAR column to autofill a date

Amelia Retureta
Amelia Retureta ✭✭✭
edited 09/14/21 in Formulas and Functions


I'm hoping to use a formula to take a YEAR DUE and return a date of 1/1/XX for the NEXT ASSIGNED DATE. I tried my best to sleuth it out but came up empty. Any help would be much appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!