Combine column data into one cell based on the status


I have a grid template that tracks the status of program implementation by state. I am trying to pull all of the live states into one cell if the status of the row is launched. Is there anyone who has been able to do something similar with a reliable formula?

I have built something similar on another template but the formula maxes out at 50 rows and breaks when a row is deleted. I would like to avoid using this finicky formula again. Any help would be greatly appreciated! Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!