Fórmula de soma com select

AppSheet AppSheet Q&A
1

sum(select(Carrinho[Quantidade], [Produto]=[_THISROW].[IdProduto]))

Tenho essa fórmula funcionando perfeitamente numa coluna virtual, porém não funciona em outra coluna normal, alguém sabe qual o erro?

Gostaria de ter essa informação na minha tabela do google

1 Like
2

While virtual column get reevaluated with each sync, physical columns recalculate only upon a data change of any column in the same row.

Hence, you can do the following:

  1. Put this formula in a physical column.
  2. Add a new column to your table, name it for example “Refresh”, with type Number. This column will be used as a counter that when you increment, will force all formulas in all physical columns in the same row to recalculate.

Now you just need to create an action to increment this counter with an expression like: [Refresh] + 1, and use automation to launch this action on the relevant rows whenever there is a change in the “Quantidade” column.