Question

How do you find the max value in a spreadsheet row?

  • 4 October 2022
  • 1 reply
  • 294 views

I was wondering if there is a way to search for the max value in a spreadsheet column and then create a variable that is (max number +1). So if the max value in a spreadsheet column is 93 it would give the value 94.

 

(Title should say column)


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

1 reply

Userlevel 7
Badge +14

Hi @Wim.GU 

Good question.

Perhaps you may be interested in using Storage: https://zapier.com/apps/storage/integrations#triggers-and-actions

 

Otherwise, add a new tab to the GSheet, then use a formula to get the MAX for the column, then use lookup that same value.

Row 1 Headers: Column A (Metric) | Column B (MAX)
Row 2 Values: Column A (MAX) | Column B (formula)