Automatic Levels?

I'm trying to include a parent row (acting as a header) in a report if a child meets certain criteria.

For example, if a child task is 'at risk' (flag is set), it will show up in the report. However, I have no idea who the parent is. I only want to include the parents of the problem children — I don't want to see every parent.

Several answers to similar questions have referenced 'automatic levels' but I'll be darned if I can actually find anything describing what an 'automatic level' is.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!