rank(collect function to rank based on multiple columns

Options

Dear Smartsheet, I wrote a function and tested it on this sheet, it should rank to also find the latest component installed based on Position & Component and then rank 1 for the most recent install date (lowest days since install). It works in this sheet with formula:

=RANKEQ([Days Since Install]@row, COLLECT([Days Since Install]:[Days Since Install], Component:Component, Component@row, Position:Position, Position@row), 1)


However when I input this formula into my other sheet in the same structure, it gives me the error #INVALID OPERATION

The funny thing is it was working in this sheet before, and then seemed to stop working, the formula is;

=RANKEQ([Days Since Install]@row, COLLECT([Days Since Install]:[Days Since Install], Teilbeschreibung:Teilbeschreibung, Teilbeschreibung@row, Motorposition:Motorposition, Motorposition@row), 1)

Thanks for any help, Paolo

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!