Workaround for error: cannot sort col1 by col2?

Hi Anonymous 

I think if you only delete two calculated columns and rebuild them, there won't show this error. Did you change the logic of calculated columns? 

Please check if there are duplicates in your column1, and if there are different values in column2 for the duplicates in column1.

Sample:

This will cause sorting errors.

Please check whether your column2 is created based on column1, this may cause an error as well.

If this reply still couldn't help you solve your problem, please share a sample without sensitive data by your Onedrive for Business with me.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.