Joining Child Rows if meets Criteria

I am attempting to write a formula in which I want to join child rows from a column titled "Assigned Workgroups/ Work Teams" if the child row has "On Hold - Pending Add'l Info" selected from a column titled "Decision Status." The outcome should be a list of workgroups/work teams on the parent row if the decision status is on hold in the column "Child On Hold Status."


I have attempted functions JOIN, COLLECT, IF, plus more. Please help!!!!

Thanks,

Jeanna

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!