Is there a way to use code to find the greatest value in a sheet

I need to find the greatest value of numbers in a sheet and add 1 to that value when a button is clicked. Please help me out here someone.

There are ways to do this in Thunkable but the easiest way is just to either sort the sheet by that column or to create a formula in another cell in the sheet that determines the greatest value and then reference that from within Thunkable.

Could you please show a coded example for this?

I don’t have a Google Sheet formula I ca share with you but you can Google it or ask ChatGPT how to do it.