Identifying which rows are CHILDREN
Our sheets and reports all run smoothly enough however where I spend most of my time is fixing indentations that correct PARENT / CHILDREN FUNCTIONS.
Our users don't pick up on the minor change in the indentation button in the menu bar which typically results in reports being generated down-stream returning figures that are lower than that displayed on a sheet.
Has anyone identified a way in which PARENT / CHILDREN functions auto-populate when new rows are added below a PARENT?
This issue is the single-handed biggest time-waster for me and the team to fix.
Help Article Resources
Check out the Formula Handbook template!