Currently, I have to make another table to track dates, holidays and weekends. This is a real pain. It would be nice if there were a setting somewhere either at the table or base level where I could select work weekends, yes or no, etc. Right now this is a really drawback.
Auto-generate or be able to set non-working dates and holidays by country
+6
+21If you want a kind of complex solution for the weekend element at least, you can use a formula to datetime format a date into it's days of the week (Monday, Tuesday, etc), then either build a filter that excludes Sat/Sun or add another formula (or probably just layer your datetime format formula) that defines those two as "weekend".
Holidays are harder, but there are Google Calendar/iCal files that you could set up an automation to import.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.