Hello,
I 've got a problem with an expressionโฆI think itโs easy for us but iโm not a pro of appsheetโฆ
Problem:
The expression (in โResultsโ) for the first row IN appsheet (โappformulaโ):
[Pears] + [Oranges] / [Markets]
For the next rows, I ALWAYS want to USE the value from cell A2 (cellโs green) but when I use the formula I wrote you above, it automatically selects A3, A4, A5 โฆ
I would like to put:
[Pears] + [Oranges] / A2
but appsheet doesnโt work like that โฆ
I donโt know what to put to select cell A2 โฆ
(I specify that it is useless that I put the formula [Pears] + [Oranges] / โ7โ because over time I will change the value of A2)
Thanks you for help.
Start here:
Iโve already watched the documentation, and I havenโt found it. Also, donโt speak very good English. Please help me.
Just put the following formula in the D2 Cell and the results will be calculated automatically
=ARRAYFORMULA(IF(B$2:B>0;((B$2:B+C$2:C)/A2); ""))
Then, regenerate the structure in your appsheet table
You can use Google Translate or we can speak spanish if you want. Im from Honduras.
If you have a table called โmarketsโ, you can count the number of markets present in that table and use it in your formula as follows:
([Pears] + [Oranges]) / COUNT(LIST(Markets[key]))
I recomend you to enclose pears and oranges with โ( )โ if you plan to divide the sum of them with the value of markets, otherwise, mathematically the formula will divide oranges and markets first and then will add the value of pears. example:
pears oranges / markets
5 + 100 / 10 = 15
( 5 + 100 ) / 10 = 10.5
Gracias pero me fallait una cosita, dondรฉ puedo encontrar la llave ?
Bueno, yo escribรญ Markets[key] como ejemplo.
el campo llave es un identificador รบnico que debes tener en tu tabla Markets, bรกsicamente la columna con que identificas cada mercado, si tenรฉs una tabla con 10 mercados por ejemplo y el campo llave o el campo principal con el que appsheet identifica los valores unicos es la columna titulada โMercadoโ entonces tendรญas que poner Markets[Mercado].
De esta forma estarรญas indicandole a appsheet que cuente los elementos en la columna Mercado de la tabla Markets. Puedo ayudarte con tu hoja de google tambien.
En Appsheet la columna principal o โKeyโ estรก marcada de esta forma, solo debes navegar al apartado Data>Columns y seleccionar la tabla que desees.
Este es un ejemplo de mi tabla Rubros que tiene una columna llamada key pero podria tambien llamarse โllaveโ. Sin embargo, nombrar bien las columnas en ingles como (key, latlong, image, name, signature, email, phone) es beneficioso porque asรญ appsheet las identifica y las marca con su tipo de dato para que no tengas que hacer mas trabajo.
User | Count |
---|---|
42 | |
34 | |
26 | |
23 | |
15 |