How can I pull a report- or write a forumula to show me Rows with a specific status?

I have created a sheet that tracks the training status of 20+ team members on ~200 SOPs. Each SOP has its own row and Team members are the columns. I want to draft a report or pull data into another sheet or easily sort SOPs based on Status for EACH team member. My goal is to be able to facilitate compliance by providing team members with atutomated status reports at a regular cadence: Which SOPs are Yellow and or Red.

I was sort the information using a pivot table in Excel- but this does not address my "automated" criteria. I know SS offers a "premium add-on" - which I don't have and likely will not be able to get. Is there a creative solution I am missing?

Thanks in advance for your help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!