Skip to main content
Question

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

  • October 4, 2022
  • 1 reply
  • 402 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)

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.

1 reply

Troy Tessalone
Forum|alt.badge.img+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)