Equivalent of 'FILTER' function


Hi there!

I am looking for a solution to the below issue:

We have a Field Employees Sheet Master that has all of our employees listed from across 16 territories. We also need a seperate Field Employees Sheet per each territory that would populate new rows in the corresponding Territorial Sheet once new employees are added to the Master Sheet.

In Google Sheet's I would simply resolve this with the FILTER function, however, there is no equivalent in SS. Report Builder would not work in this case as well, since I need to add additional rows to the Territorial Sheets that are not a part of the Master Sheet.

For easier reference, I am attaching a picture of an example 'Master Sheet'

and Territorial Sheet for Territory B

Do you have any suggestions on how to resolve this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!