Help with Column formula for Parent rows only.

Hello, I am trying to implement a Column formula that will only register on the Parent rows. After some research on here I have assembled a formula that I believe should be working, but instead leaves all Columns blank. (Formula works as intended in individual parent rows, but once I apply the formula to the entire column, all of my cells become blanked out. No errors are shown). The formula is intended to reference the child row with the highest Row ID of each parent, and copy that cells value to the parent row.

The formula is: =IF(COUNT(CHILDREN()) > 0, INDEX(CHILDREN(), MATCH(MAX(CHILDREN([Row ID]@row)), CHILDREN([Row ID]@row))))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!