It is possible to put formulas. Only restriction is data cannot be sorted.
Copy the whole data and paste it other sheet by
Paste Special--> values.
Then data can be sorted in that sheet. Is it ok.