How to show last passed child on parent row?

I have been trying different ways to show last passed "gate" of a project. The project can have from none to few child rows. There is a column with passed gates as tick marks.

Now I want to show the last passed gate text side by the parent row. I haven't figured out how to do this automatically.

Any help is welcome!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!