PTO ACCURAL TO REFRESH ON JAN 1ST

Has anyone figured out how to refresh the pto accrual on Jan 1st?

This is my formula that works fine in this current year: =IF([EMPLOYMENT TYPE]@row = "FULL-TIME", [WEEKS WORKED FROM START MONTH AND DAY TO DATE]@row * 1.66, 0)


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!