Most recent date

Sophie Humphrey · 02/26/21

Hi all,

I hope you are well! I'm looking to have a parent row that includes the number of people a project has been deployed to, with children rows that will be added and updated when relevant (weekly/monthly). I'm hoping to pull through the most RECENT date information into the parent row and an to have the option to drill down and see the weekly/motnhly change if you want. I'm struggling as there won't be a set number of "children" rows. Hoping you can do a formula searching the children rows and returning the most recent date and its relevant data?

In the example below I would like it to state: Deployed to: 70, Usage: 60

Sean Morgan · 02/27/21

Hello @Sophie Humphrey ,

You could use a combination of both MAX + CHILDREN. Please see my below example:

As you can see here, I have a text Column, and 2 Date Columns. In the "Most recent Date" Column, I added this Formula : =MAX(CHILDREN([Date Column]@row)). [Date Column]@row refers to the Parent Date Cell

When I added a new child row under "Test 1" with a later date, you can see below that the date changes:

For more on the functions used, you can see these below:

MAX: https://help.smartsheet.com/function/max

CHILDREN: https://help.smartsheet.com/function/children

Let me know if you have any questions!

Regards

Sean

Sophie Humphrey · 02/26/21

I realise I can do MAX and just extend the range every time a row is added but looking for a more efficient way :)

Sean Morgan · 02/27/21

Hello @Sophie Humphrey ,

You could use a combination of both MAX + CHILDREN. Please see my below example:

As you can see here, I have a text Column, and 2 Date Columns. In the "Most recent Date" Column, I added this Formula : =MAX(CHILDREN([Date Column]@row)). [Date Column]@row refers to the Parent Date Cell