Index Collect Formula works perfectly in everything except a Parent row.

Options

My index Collect Formula works perfectly in everything except a Parent row, does anyone have a solution? This is the current formula - =INDEX(COLLECT({Task}, {ID}, [Ops Plan ID]@row), 1)"


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!