Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Structure - get value from child row with max date

larry joseph
Contributor
December 13, 2023

Hi, I want to set the value  on a parent row to a value from it's child rows with the max date.

 

Ex:

Parent (this is a project-component row)

  version1  12/1/23

  version2  12/5/23

  version3  12/2/23

 

I would like to have the result of the formula be version2 in this example.

 

I tried this but it doesn't work.

 

if itemtype = "project-component" : values#children{if created = max#children{created} : version }

 

I'm unable to figure out how to get a match on the child row that has the max created date.

 

0 answers

Suggest an answer

Log in or Sign up to answer