Is there a FILTER function in Smartsheet, which is equivalent of Filter function in excel ?


I want to find out the stack rank percentile (i.e. where the employee stands as top 10%, bottom 10% or middle 90%) of each employee in her department in a list of employees from different departments depending on what 'Stack Rank' has been assigned to that employee by her Department Head in that Department. For example, what is the stack rank percentile of 'Jane Joe' in the Sales Department. I think the 'FILTER' function of excel allows you to extract an array of the Sales department, but this function does not exist in Smartsheets. Can you please provide the formula that I can use to achieve the stack rank percentile for each employee in the list given below.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!