Formula to populate the last count/date of the newly added row
Hi,
I am trying to see if there is a Formula to populate the last count/date of the newly added row under each Indent. For example, in at attached image when I update numbers every quarter, I manually update the new count on top and the last updated end date.
Thanks,
CK
Best Answer
-
If you are pulling the data into the parent row of the same column then you should be able to use the formula I provided exactly as is.
So if you are trying to get the most recent quarter from the child rows into the quarter column on the parent row, you shouldn't have to change anything from my formula.
Answers
-
Try this:
=INDEX(CHILDREN(), COUNTIFS(CHILDREN(), @cell <> "")
-
Hi @Paul Newcome ,
Thank you for responding!
Can you elaborate more, please? So, if I wanted the top row for example for Asthma count from the screenshot to equal exactly the count that was added in the last row of the indented group and the same thing with the last date field on the right which is the End Date file. How will your equation fit?
=INDEX(CHILDREN(Count PTTS), COUNTIFS(CHILDREN(),@cell <> "")
Thanks
-
If you are pulling the data into the parent row of the same column then you should be able to use the formula I provided exactly as is.
So if you are trying to get the most recent quarter from the child rows into the quarter column on the parent row, you shouldn't have to change anything from my formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!