How do you reference 'Created' column date of a PARENT and add one calendar year?

Steve Weston

Hi all,

I am trying to do the following:

For a given cell, I would like to reference its Parent's Created date and return a date that is one year in the future. I think I'm just struggling with finding the correct syntax.

Bassam Khalil

Hi @Steve Weston

Hope you are fine, please try the following formula and convert it to column format formula:

=IFERROR(IF(COUNT(CHILDREN()) = 0, PARENT([Created Date]@row) + 365, ""), "")

the following screenshot shows the result: