Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 10, 2022 08:00 AM
Hi Everyone, I am trying to build a simple PTO tracker for my team. I have my list of employees and I would like to add a column with a formula that create 1 PTO day per month but I dont have clue on how to do it. Any help on this please?
Thanks!
Oct 10, 2022 09:13 AM
If the requirement is just a simple incrementor that gains 1
in value each month, it should be pretty simple.
Assumptions:
IF(
{Start Date},
DATETIME_DIFF(TODAY(), {Start Date}, 'months')
)
Oct 10, 2022 10:06 AM
Thanks so much Jeremy! it was so helpful. And one more question, what about for those employees who has 2 weeks per Year, which formula can I use to do a monthly accrual of this case? Thanks!
Oct 11, 2022 02:00 AM
Multiply the above formula by 0.833333333
Assuming 2 weeks/year is 10 days per year. Maybe use a round()
or rounddown()
formula to process it.