Most recent date
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
Best Answer
-
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
Answers
-
I realise I can do MAX and just extend the range every time a row is added but looking for a more efficient way :)
-
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
-
@Sean Morgan I had a feeling it would be that simple! Thank you for your help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!