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!
Best answer
Is there a way to use Google Sheets to remove data from a specific cell based on its content?
- Beginner
- 1 reply
Best answer by Lars
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.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31058 replies
cc:
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
+1- Zapier Staff
- 21 replies
- Answer
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.