Expand Count formula (To provide a list of names from another column)

Hi All,

This one may not be possible, but will drop it into here to see if it is, thanks in advance for your help.

I have a "COUNTIF" Statement in place which is counting the number of times "Red" is listed in a column.

In a corresponding column I have a reference to a company name which I would really like to display on a Dashboard.

Is there a way to reference COUNTIF value, then list out corresponding company names from a difference column?

Would like to use formula to ensure were capturing any updates to the data sheet, without Manually tweaking it.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!