Question

Adding +1 to a cell.

I’m looking to have my webhook add +1 to the number already in a cell. I’ve tried =(c8)+1 but getting a #REF error.

Any ideas how I can take the number already there and add 1 to it?

Did this topic help you find an answer to your question?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+14

Hi @BFT

Good question.

Try these Zap steps:

Trigger: ???
Action: GSheets - Lookup Row
1. Used to get the current value of the desired column cell
Action: Formatter > Numbers > Perform Math Operation
1. Operation: Add + 1
Action: GSheets - Update Row
1. Map the Row ID from Step 2

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

+12

There are some really great articles out their that reference how to use formulas with GSheets

2 replies