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)
Page 1 / 1
Hi
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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.