Can I filter a column but keep intact other rowsl?

Shlomo Stein
Shlomo Stein ✭✭
edited 02/08/21 in Formulas and Functions

Can I filter 1 column without it affecting the data in other columns?

For example, filter only Bank Credits, but leave all other columns in full without removing any rows from other columns.

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 02/09/21

    Hi @Shlomo Stein

    Hope you are fine, each row in your sheet represents a record and when you filter any cell in the row all other cells in the same row will follow. ie ( if you have in same row Name - Mobile - Address and your filter hide the name also the mobile and address in the same row will be hidden ).

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!