Search Projects as Per RYG status

A filter would work if you are wanting to see the whole row for those specific tasks and nothing else. If you would like a listing of just the task names displayed in a cell, you could use something along the lines of

=JOIN(COLLECT([Project Name]:[Project Name], Status:Status, "Red"), ", ")

The result would display in a cell as 

Project 1, Project 4

You can create a Smartsheet Report which will only show you the Red projects. Here are some helps around creating reports: 

• https://help.smartsheet.com/videos/smartsheet-reports
• https://help.smartsheet.com/topics/reports-dashboards

Give this a try...

=JOIN(COLLECT([Task Name]:[Task Name], Status:Status, "Red"), " - ")

In your example above, the formula would return

Project 1 - Project 2 - Project 3

all in the same cell. You could change the delimiter to whatever you want.

This will pull ALL tasks that are "Red" into one cell. You will probably want a wider column with text wrapping if you anticipate more than one or two tasks being pulled at a time.

I use something very similar to this in Parent rows as a summary for what is still outstanding while keeping the sheet looking a little more organized instead of having to sift through over a thousand rows.

Glad we could help you out.