Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

JOIN COLLECT - PARENT criterion

Hi there!

I'm doing a cross sheet formula where I want to collect Task Names if the IP Submission Return of the child row (10/12/24 in this example) matches the Most Recent Update of the parent row. The Most Recent Update column utilizes the formula =MAX(DESCENDANTS([Actual IP Submission Date]@row), DESCENDANTS([IP Submission Return]@row)).

Here is a look at the reference sheet {Approval Tracker}.

This is my current formula:

=JOIN(COLLECT({Approval Tracker Name}, PARENT({Approval Tracker Recent Update}@row), {Approval Tracker IP Return}), CHAR(10)))

It returns #UNPARSEABLE

I do want to add another criteria, but I've already got that one working, so I'm not worried about that yet.

I'm pretty sure the issue is with the PARENT formula, but I can't figure it out. Please help!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions