Help

Calculating a date in an Automation using the repeating groups feature?

Topic Labels: Automations
488 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lindsay_Patross
6 - Interface Innovator
6 - Interface Innovator

I've been creating long automation to add a list of tasks every time we get a new project. I create one automation and then add a step for each new task. 

I just saw the repeating groups function and I wanted to try this. 

So I added a table called "Tasks for automation" 

I need to be able to set the task due date to be a calculation based on the project due date. Each task will have a different due date.

Task 1: Due Date = project due date - 28 days. 

Is there anyway to create a date from a calculation 

1 Reply 1
Jason_Hill
6 - Interface Innovator
6 - Interface Innovator

Assuming {due date} is a date/time field, you can create a new field called {project due date} and set it to a formula field. You can use this formula: DATETIME_PARSE({due date}) - 28