List an ancestor value if a child meets a condition

I am trying to write a formula to return the value of an ancestor if a checkbox cell is checked.

For context, I need to see if the ancestor and all child cells are relating to an event. The sheet has a mix of events and other projects, and there is a checkbox column to mark if it's an event. The checkbox is checked at the row of the event, which will usually be called 'event' not the actual name (eg. Christmas Party).

How can I write a formula to check if a row's child cells has the event checked, and if so return the ancestor project name?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!