Question

Adding +1 to a cell.

  • 1 July 2022
  • 2 replies
  • 32 views

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? 


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

2 replies

Userlevel 7
Badge +14

Hi @BFT 

Good question.

Try these Zap steps:

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

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