Looping dynamic value in different tables

[AndreaSangalli]

Hello
Can you make Appsheet recognize a formula typed into Google sheet as text?
I have a table with 2 column and I want give to the user full liberty to customize they own value.
The first column is a static value and I don’t have any problem, but the 2 column si a dynamic value and is an average between different value in a different table and the value are chasing Daily with no corellation With the column.

Thanks in advance

[dbaum]

@AndreaSangalli

Can you make Appsheet recognize a formula typed into Google sheet

Yes - Spreadsheet formulas - AppSheet Help.

@AndreaSangalli

as text?

No. It needs to be entered as a formula.

@AndreaSangalli

the 2 column si a dynamic value and is an average between different value in a different table and the value are chasing Daily with no corellation With the column

Consider using a virtual column.

[AndreaSangalli]

Thanks for the feedback!!

In my case I want to use an appsheet formula to calculate the value, because with the regular google sheet I’m worry that I have to use the Query function.