Search Projects as Per RYG status

SBash ✭✭✭✭
edited 12/09/19 in Formulas and Functions


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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!