How to sort values using formulas? INDEX(COLLECT, COLLECT, VLOOKUP?



I am trying to sort the values (Machines) based on the "OEE Current Month Column" and referred it to the "OEE_C" (used Large formula). I have used 3 formulas to get the CM Machines sorted based on the OEE_C,

first I have used VLOOKUP but when it reached the same values it stop showing data or leave it blank. 2nd, I used INDEX(COLLECT, and it gives me the same Machine name. I used Collect but it gives me column error.

Can anyone help me to resolve this?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!