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

Question

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)

Troy Tessalone · Answer

Hi@Wim.GUGood question.Perhaps you may be interested in using Storage: https://zapier.com/apps/storage/integrations#triggers-and-actionsOtherwise, 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)

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded