Filter display

ydionne
ydionne
edited 12/09/19 in Smartsheet Basics

Hello,



I need a little help to get the filter to work properly.

In a report, I applied a filter to get a display based on people and later by date but the display does not give the right result.

You can see with the screen shoot

Thanks

Smartsheet filter.png

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    There is currently a known bug that prevents sorting by a contact column field. To get around this... try adding an additional text column called HELPER to your main sheet. And populate the entire column with this formula =Estimateur@row.

    Head back to your report and add that additional column to your report, then you can sort by the Helper Column and get what you are looking for. 

  • Thanks Mike,

     

    It solve the filter problem