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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!