Example: WHEN {PARENTITEM_TRIP_TYPE_COL} = “MY_TYPE” ADD PARENTITEM_SUBITEM called “DINING RESERVATION” SET SUBITEM_DUE_DATE to 30 days before PARENTITEM_TRIP_START_TRAVEL_DATE I have the formula to take date 1 and set date 2 30 days before date 1 within an item. SUBTRACT_DAYS({Start Travel},30) …

Formulas: Reference parent item column from sub item formula column

JoeC (Joe) May 23, 2023, 1:37pm 5

Have you found a solution to this?

Topic		Replies	Views
Feature Request: Work Backwards From A Date: Access parent item columns in sub item creation for Automation and Formulas Feature requests automations , formula	1	1588	January 2, 2022
Help with calculating due dates between subitem and his parent item Platform discussions formula , subitems	13	3229	April 14, 2022
Sub-item date query Platform discussions	4	1516	September 14, 2021
Sub item column value on parent Special workflows & use cases columns , formula , subitems	0	1812	September 11, 2022
Subitem mirror parent item Feature requests automations , columns	3	1604	October 4, 2023