Most recent date
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
Help Article Resources
Check out the Formula Handbook template!