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.
Answers
-
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.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 409 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!