Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Sort columns by color

Ellen Friedman
Ellen Friedman โœญโœญ
edited 12/09/19 in Archived 2015 Posts

Hi,

Is there anyway to sort columns by fill color or text color? When we need to draw attention to certain items in Smartsheet In Excelย we use color coding to sort. That ensures that the specific criteria requested will be presented on the top...(not all the criteria are the same ex. by date, so conditional formatting won't work).

Thank you

Comments

  • Zack S
    Zack S Employee
    edited 10/19/15

    Hello Ellen,ย 

    ย 

    Currently there isn't a way to sort rows or a column by background color or text color, but I'll add your vote for this capability to our enhancement request list.ย 

    ย 

    Similar to conditional formatting, at this time you can only sort by a certain column criteria such as by date.ย 

    ย 

    -Zackย 

  • Stan Ward
    Stan Ward โœญโœญ

    I would also be interested in sorting by color.ย  I sometimes use color coding of a "category" column, with the color being the large macro category and the text value for a more specific category.ย  It gives two dimensions to the categorization with one column.ย  When using reports, it would be great to be able to sort by both the color of a cell (and possibly other attributes) as well as the cell value.

  • A O
    A O โœญโœญ
    edited 02/29/16

    I would also be very interested in being able to sort by color, i have dates which turn red when expired and i would like those rows to move to the top of the spreadsheet to be noticed. It is extremely important to us that the feature be added! Thanks for listening and taking note of the customer requests.

  • JohnHinkle
    JohnHinkle โœญโœญโœญโœญโœญโœญ

    A O, can you just sort based on if the date is expired? The same criteria you use for conditional formatting could probably be used for sorting.ย 

  • A O
    A O โœญโœญ
    edited 03/01/16

    That would work, but the problem is that there are 2 different dates on the page.

    If it sorts by color, any date on the pageย that expires would turn red and move to the top.

    But if i do it by date, i can only make one date (one column)ย move to the top.

    ย 

    So i still need the sort by color if i want my sheet to work properly.

    ย 

    Thanks for the help!

  • Dave Roush
    Dave Roush โœญโœญ

    We do a lot of work in Trello and have become dependent on assigning multiple labels, which are color coded, to our cards. ย It provides a very visual display of card states by color. ย It seems Card View only supports one color per card and that there is no algorithmic way to set that color (e.g. by conditional formattin). ย Is this ture?

  • Hi Dave-- To confirm, we do only currently support one color per card and we don't yet flow row formatting (i.e. cell background color, font size, etc.) into cards. However, it is possible to change the color of the left-hand side of a card with Conditional Formatting. You can do this by setting up a Conditional Formatting rule and choosing a "Task Bar" color from the formatting menu. This applies to bars in the Gantt chart, tasks in the Calendar view, and card colors in the Card View. Hope that helps!

  • Dave Roush
    Dave Roush โœญโœญ

    Hi Kennedy, thanks for the claification. ย I'll give the conditional formatting a try. ย I'll keep rooting for you to add more capabilities to your Trello imports. ย It would be tough for us to switch at this point, but we would love to use one single tool for card visualization and a more traditional project managment approach where we can establish dependencies between "cards". ย Keep up the good work and we will keep checking for new capabilities.

  • stuartweitzman
    stuartweitzman โœญโœญ

    would really like the sorting feature by color, when do you think this will be available??

  • Michael Smith
    Michael Smith โœญโœญ

    Is there a time-line for the sort by color feature?

  • karen_berard
    karen_berard โœญโœญโœญ

    Has there been any update regarding being able to filter by color?

This discussion has been closed.