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?
User | Count |
---|---|
16 | |
7 | |
6 | |
3 | |
3 |