Can I do this formula in Appsheet? trunc(vlookup(RC[-2],Inv!R3C2:R6C8,7,false)*RC[-1]/Inv!RC9)
This is a spreadsheet formula not appsheet formula
@Cubyl yes it is, but, Can I apply it to appsheet?
In a spreadsheet formula but only for update or add new row. Inside of the property of the column you have in the last bottom editor, spreadsheet formula and you can insert there
You need to use ; not ,
Spreadsheet formulas in Europe use ;, but in the US the use the comma instead.
+Javier Coronel, no we have not implemented trunc and vlookup. And the RC format doesn’t make sense in AppSheet. However, you can do something similar with app formulas.