Data Entry With a Filter

CherylAK
CherylAK ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

OK - I have a sheet that tracks our invoices by VENDOR.  We have several vendors in alphabetical order as the "parent" rows and underneath each vendor are their respective invoices (children).

The sheet is long so I create a filter to pull up a specific vendor.  In the first blank row under that vendor I type in the information and then I save it.  I take off the filter and the row is GONE.   If I filter again and select the same vendor...the row that disappeared is still there.  Filter off..gone!

When I type the information in without using the filter...I just scroll all the way down until I find the vendor I want and then type in the information and save it.  It stays there.

So how can this be?  I hope someone can help me figure this one out!  Thank you.

Comments