Is there a way to sort a columns values from high to low?

RickyT

RickyT ✭✭✭✭✭

10/09/23 in Formulas and Functions

Im trying to see if I can get the column to sort the row values from highest to lowest and am not sure how to do this.

Ricky T

Gov Contractor for USSF

0 ·

Answers

RickyT ✭✭✭✭✭

10/09/23

Found a way using the Row sort function but its not permanent...

Ricky T
Gov Contractor for USSF
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Due Date based off a workday schedule - Need Workday Formula Help
Hello everyone. I'm trying to use a WORKDAY formula to auto-update a list of due dates. We have several financial tasks that must be completed a specific workday every month. For example, the books need to be opened -1 to the start of a new month. But this needs to be a workday. I have been trying to setup the formula so…
Calculating age between two dates issue
I am trying to calculate student's age in years & months based on a future date. If the birthdate occurs before the cut-off date, the formula I have works fine. If the birthdate is after the cut-off date the formula is not calculating correctly. I am not sure how to fix this:
Using =Value to return a number but gettting error
I have the following cells that I need to use in an Index(match I cannot control the format, and ideally would like to resist using a helper column. The numbers vary in length and the blank spaces, "-" and leading zeros become an issue with Index(match. The formula I am working with to adjust and want to use for the Match…