Move Due Date By Number of Days In A Custom Field

tkelly

 I want to move the Due Date for a Trello card x days, based a number in a custom field. There are only static choices.

 

 

In my card, the Due Date is 5/21 and my total lag is 2.0 (meaning 2 days).

 

I want a triggered automation to move May 21 + 2 days = May 23.

I tried the following in the Set Custom Field for "Date" (thinking this is the built-in due date) to {{%Date}+{%Total Lag}wd}}

That gives me the error Couldn't find a Custom Field called "Date" in card https://trello.com/c/ixxx. Please make sure that the Custom Field exists with that exact name.

Does anyone have a guess how I can increment the due data based on the numeric field with the numeric field represents "Days"?

Thanks in advance! Tim

Hannah Humbert - Simpla Workflows

Hi @tkelly for the moment, Trello doesn't allow you to set a variable in the native due date field.

Here is a workaround though:

1. Create a custom date field called "Date" (choose the option to not show on the front of the card).

2. Create rule: 

when custom field "Number" is set, set custom field "Date" to "{{%Date}+{{%Total Lag}}wd}”

3. Create another rule: 

when custom field "Date" is set, set due date on the date in custom field "Date"