Date, formatting and Arithmetic

Sanjay Rajan_63n60v

Hello, 

Can any expert please advise how to go about writing this rule?

For background, I've 4 custom fields:

Planned Start date: Date format

Planned End Date: Date format

Number of days required: Number format

Number of days on leave: Number format

here are example values

Planned Start date: 6 May 2024

Number of days required: 6 ( this is actually 6 working days)

Number of days on leave: 1

The rule I want to write in plain english is:

When 'planned start date' AND 'number of days required' And 'Number of days on leave' is filled out/changed, set Planned End Date = Plannned Start Date + Number of days required + Number of days on leave.

Output should be Planned End Date: 15 May 2024 ( 7 working days from Planned Start Date)

Problem is when I use set custom field, I cant see the date custom fields.

And when I use set date custom field, the option has now which is will mess up the logic. 

Please advise. Thanks. 

Mat_w4y9na

Hi Sanjay,

Thank you for explaining your use case in more detail. I have these fields setup in my example:

1. PlannedStartDate - date custom field
2. DaysOnLeave - number custom field
3. DaysRequired - number custom field
4. PlannedEndDate - date custom field

I was able to setup a trigger that looks for changes in the DaysOnLeave custom field, as long as you have the PlannedStartDate and DaysRequired custom fields complete.

Once this triggers, it sends a sequence of actions to simulate this formula: 

1. PlannedEndDate = PlannnedStartDate 
2. PlannedEndDate + DaysRequired
3. PlannedEndDate + DaysOnLeave

For example:

1. PlannedEndDate = 6 May 2024
2. PlannedEndDate = 6 May 2024 + 6 working days
3. PlannedEndDate = 14 May 2024 + 1 working days

PlannedEndDate = 15 May 2024

This is how it looks:

To setup the last 2 actions, you can select this option below:

For reference: https://support.atlassian.com/trello/docs/arithmetic-and-formatting-in-date-variables

I hope this helps, but let us know if you have any questions or need clarifications!
----------------
If this post helps with your query, then please consider the Accept answer or Like button to help the other users find it more quickly.