Data Entry With a Filter
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
-
Hi Cheryl,
It's because the row you are typing in the information on probably isn't the next row. If you check on the left side, you can see which row it is, and you should be able to find it.
A possible workaround could be to add a few "empty" rows that match the filter so you can fill them in in the right position directly.
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you Andree! You are awesome!
-
Wow, Thanks!
I'm always happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives