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
-
I think I need a new column that says "Weeks worked from Jan 1st-today" and then make my formula off of that rather than "weeks worked from start date" but I need help with that.
-
Ok, i think i am having a conversation with myself but i might have figured it out by adding two additional columns. if there is an easier way, please let me know.
=(TODAY@row - [New Year - Jan 1]@row) / 7
-
Hi @NikkiOno
I'm glad you figured out a solution!
If you wanted to eliminate the "New Year - Jan 1" helper column, you could use the DATE Function within your formula to lock onto January 1st, like so:
=(TODAY@row - DATE(2023, 1, 1)) / 7
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. that worked! thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!