Using spreadsheet formula comparing to virtual column

My first Question:

If I have these options to my app:

1-  Spreadsheet formula (Arrayformula)

2- Virtual column

Which option would be better to the performance of my appsheet?

My Second Question:

If the better option is to use virtual column instead of arrayformula:

what should I do, if I need the computed values in my database?

My Third Question:

What is the maximum number of virtual columns which I can use without slowing my app performance, (or how I can use it effectively) ?

My Last Qustion

If I have a VLOOKUP formula in appsheet row, is there a way to update its value on all rows when the app starts?

0 10 346
10 REPLIES 10
Top Labels in this Space