How to get a value from list view onto form?

How do I get a value from a list view to so that I can use it in a formula on the form view.

I have a field in list view A2 with numerical values, how do I access something like max(A2) and use it in form view on a new record i’m creating, ie: max(a2)+1.

thank you!

Hi,

Currently, formulas only can refer fields on same entry, if your calculations that have to look over different entries or sheets, you would need custom Javascript workflow to achieve this.