I have columns in a google sheet where I place an “x” in the appropriate cell column to signify that a client has that particular service.
In the zap I'm locating the correct customer row based on their email address and then using the “update row” option to add an “x” in the correct cell column for the service they have purchased.
I have not been successful being able to clear an existing “x” from a cell column using this same method. I tried to just type a “space” with the spacebar in the column that I want to clear the “x” from, however that doesn't seem to work.
Is there another way to get this to work?
Update Google Sheet Cell by clearing it
Userlevel 1
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 23819 replies
-
17 October 2020
You could use a formula instead for the value of the cell.
=”X”
OR
=””
Userlevel 7
+10
- Certified Zapier Expert
- 2437 replies
-
15 December 2020
Hi
Just checking in, did you manage to get this sorted?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.