Search Projects as Per RYG status

SBash

Hi, 

I looking for solution or moreover a formula to get a project name back as per RYG status.

But i am getting problem, i have a same RYG for more then one projects.

For example: i want a list of projects As RYG "RED", the selection has to show me 2 projects in retuen

Project 1       Red

Project 2       Green

Project 3       Yellow

Project 4       Red

Project 5       Yellow

 

Many Thanks

Sbash

Mike Wilday

It sounds like you might want to create a filter that you can use to review the data you want.

https://help.smartsheet.com/articles/504659-using-filters-to-show-or-hide-sheet-data

Paul Newcome

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

SBash

Hi Paul, 

Many Thanks for the response. 

It show all result in on cell. I want to create a report that all Red project will be displayed.

For example,

Project 1       Red

Project 2       Green

Project 3       Yellow

Project 4       Red

Project 5       Green

Project 6       Yellow

Project 7       Red

Project 8       Green

Project 9       Yellow

So, without using filter option, is there any possiblity that if i give command that show me all Red projects, and i will see only list of Red project. in above case Project 1,4,7

is there any formula for this

Many Thanks

 

Mike Wilday

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

Mike Wilday

But there is no way, other than creating and selecting a filter to immediately see all the red projects. 

Paul Newcome

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.

SBash

Hi Paul, 

Many Thanks. 

I think i will use filters and attach the linked (Attached) the filtered report in Dashboard

Best Regards

Saqib

SBash

Hi Mike

Many Thanks. 

I think i will use filters and attach the linked (Attached) the filtered report in Dashboard

Best Regards

Saqib

Paul Newcome

Happy to help! 

Mike Wilday

Glad we could help you out.