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

Sonal Dubey

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.

Bassam Khalil

Hi @Sonal Dubey

Hope you are fine, Unfortunately, this feature is not currently available. You can submit a Smartsheet Product Enhancement Requests using this form.

but you can do that by using the new report builder with the amazing filter options.