RankEQ formula by group
Hi,
I'm hoping to make the RankEQ formula have a criteria component to the ranking to rank overtime on deck per shift instead of by the whole group. We keep all the information on a larger spreadsheet and have a ranked report available to all staff.
The column headers are below:
Thanks for any help!
Best Answers
-
RANKEQ([OT Hours]@row, COLLECT([OT Hours]:[OT Hours], Shift:Shift, Shift@row))
Hi, @Amelia Retureta, the formula above will do that. Here's how it works:
Use COLLECT() to return the range of OT Hours for the shift. Having retrieved the range, use RANKEQ() to rank the current value within it.
Cheers!
-
That worked great, I only had to add the ,1 between the ending parenthesis to rank lowest to highest.
RANKEQ([OT Hours]@row, COLLECT([OT Hours]:[OT Hours], Shift:Shift, Shift@row), 1)
Thanks for your help!
Answers
-
RANKEQ([OT Hours]@row, COLLECT([OT Hours]:[OT Hours], Shift:Shift, Shift@row))
Hi, @Amelia Retureta, the formula above will do that. Here's how it works:
Use COLLECT() to return the range of OT Hours for the shift. Having retrieved the range, use RANKEQ() to rank the current value within it.
Cheers!
-
That worked great, I only had to add the ,1 between the ending parenthesis to rank lowest to highest.
RANKEQ([OT Hours]@row, COLLECT([OT Hours]:[OT Hours], Shift:Shift, Shift@row), 1)
Thanks for your help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 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!