How do I reference a custom field value in the action portion of an automation?

[Curtis Furniture]

I have the below automation set up on a board where I have custom fields named "Number of Phases", "Phase 1 Start Date", and "Phase 1 End Date". I also have custom fields named "Phase 2 Start Date", "Phase 2 End Date", "Phase 3 Start Date", etc. The rule is triggering fine, (e.g. when "Number of Phases" is set to 2 and fields "Phase 2 Start Date" and "Phase 2 End Date" have been filled in the item " Complete Full Survey" is added to the correct list)

My issue comes when I try to set the due date for this item. I am using the exact same syntax in an attempt to refer to the date in the custom field "Phase 2 End Date" in this example. When I run the automation, the log shows the error "Couldn't find a Custom Field called "Phase {customfieldvalue} End Date" in card..card link here....Please make sure that the Custom Field exists with that exact name." Is there a different syntax I need to use in the action portion of my automation? I have also tried replacing "Phase {customfieldvalue} End Date" with "Phase {{%Number of Phases}} End Date" with the same result.

[DiMaggio Tucci]

Hey there, @Curtis Furniture ! Sorry to buzz you so much; it took me a couple of attempts to give a correct answer.

I created a similar example using a different method and I tested it and it worked!

Here are the rules I created:

So, in essence, We can't set the date using that bracket syntax. Instead, we can use bracket syntax when setting the date of a custom field. So we create a custom field "Logic Date" and set that INSTEAD of the due date, since we can use bracket syntax there.

Then, we can use "Logic Date" to set the due date.

You could then clear the date in "Logic Date" if you wanted.