Is there a way that if data is found in a particular cell then it removes that data. I thought to put a space in, but then makes the if data exists / not exist filters not work. Anyone know if that’s possible? Thanks!
Is there a way to use Google Sheets to remove data from a specific cell based on its content?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Hi
As you’ve found there isn’t a way to properly clear a single field at a time. It’s something we’ve heard several times and are looking at potential solutions.
For now, as you’ve explored, most users will put in placeholder data like “n/a” and use that for filtering.
Thank you for raising.
Thanks
Thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.