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!!!!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!