Forum Discussion
how to make the sort function work dynamically/automatically
I have a spreadsheet of values that is sorted by a column that has a formula in it, where the values of that formula come from market inputs etc. Id like my list to sort itself automatically when o...
Use SORT() function.
Thankyou for replying, but I am non the wiser with what to do, am already using the sort function.
AndrewCaris Can you share a sample file via OneDrive or GoogleDrive so that we can understand your problem clearly and provide you best solution? Show your input data and desired output.
- https://docs.google.com/spreadsheets/d/1YEfiT8-vVcQ1yYgQUqxwdgZtEXrJFwLe/edit?usp=drive_link&ouid=105553809831879272556&rtpof=true&sd=true
I want it to sort by total/year whenever input is changed at g4 and h4. ThankyouFile is not accessible, you need to share it with everyone.
