đŸ§Ș 12 Formulas to get you started with the new Advanced Editor

Ooh that’s a tough one @Arthur_BEGOU, but doable. I have built similar systems but not one that adds earned leave days throughout the year. Conceptually, I would approach this as per @lpb good tip here whereas a “Leave days” number field has positive values for ‘earned days’ while the ‘leave days taken’ would be negative values, thus getting a sum of how many days are left.

The negative leave days would be generated by a leave submission form, which could be processed within a ‘back-end’ project before any ‘approved’ leave days are then added to a public ‘approved leave days’ project for all to see. I use Flowsana.net to invert the positive values (inserted from the form) to negative values - otherwise, the HR member/reviewer can insert these manually, based on the requester’s leave start/end dates.

In a separate ‘back-end’ project (managed by HR), I would set up everyone’s ‘earned leave days’ as one task for each person which recurs every 2 months with a +2 days number value. With a rule that when dude date is today → complete task, then upon completion, it would create a new task for another +2 days. All these tasks would be multi-homed to a comment-only member-facing project, filtered by dynamic ‘Me’ so they can only see their leave days left. Alternatively, if you have a small team, you could set up one private project per member, which could all roll up into a Portfolio so that HR/MGMT can also see each person’s leave days left.

I think you get the gist, all this can run using rules, and, as you can see, without any formulas included - they will not do this for us just yet. I am planning on creating a video series for everything around leave days
 hopefully I’ll get around to that soon, maybe before this is all natively possible within Asana! :sweat_smile:

2 Likes