How to create a running increment for a Specific cell value in excel

Hi @NovoPath 

Try this Zap action: Storage - Increment Value

Store help: https://zapier.com/apps/storage/help

Hi @Troy Tessalone 

I will look into this and get back to you! How does this solve the lookup issue? It seems the issue of using the current value (Incremented value) as the lookup value will be ever existent since I need to always find row before updating row? 

FYI my steps are

1.New Ticket from Zendesk 

2.Find row in excel by column “priority urgent tickets” 

3.Find current value in row 

4.Increment value by +1

Thus, when zap is on, every ticket submitted would increment current value by +1

Thanks, 

@NovoPath 

If you are trying to update an existing spreadsheet row, then you will need to use a Lookup Column and Lookup Value that corresponds with the Customer ID and/or the Account Name.

Hey @Troy Tessalone , 

I believe I understand this, but at the end of my zap the lookup value always changes per the incrementer. 

So orignal lookup value could be 0 

When a new ticket comes in incrementer will adjust the value from 0 to 1. So everytime a new ticket comes in then, my zap will fail in theory because it looks at “0” instead of the current value “1”. 

Hoping I made sense there, 

@NovoPath 

EXAMPLE

If you are trying to update the spreadsheet row with Customer ID = 0015e…

The Zap action: Excel - Find Row would use Lookup Column = Customer ID and Lookup Value = 0015e…

That will return the current data from the matching row.

Then you can use the Formatter > Numbers > Perform Math Operation to ADD the current value and a value of 1. (e.g. 0 + 1 = 1)

The you use the Zap action: Excel - Update Row to update the row using the Row ID to set the new column value.

@Troy Tessalone 

Oh my stars, for the life of me, I thought that finding rows had to be column associated, so vertical lookups as opposed to horizontal. Jeez o peetz! 

It worked! 

Thank you so much sir,