The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hi there,
I would like to create a table to count and assign 25 holidays per year to employees.
I’ve managed to create a formula that sums holidays excluding national holidays and weekends but I would like to create a field called “Days Left” with a ...
Thanks! That worked just fine, although I find it a bit fuzzy to create two tables for one function…
My last question would be if there is a way to have this formula renew the 25 days of holidays per year automatically. To demonstrate, I’ve added hol...
Thanks for your response.
I tried both but neither worked.
It does work for a single line / record, but won’t add up all holidays as employees take them.
See image below to illustrate: