Can I do this formula in Appsheet? trunc(vloo...

(Marlon Xavier Medina Cisneros) #1

Can I do this formula in Appsheet? trunc(vlookup(RC[-2],Inv!R3C2:R6C8,7,false)*RC[-1]/Inv!R[1]C9)

(Cubyl) #2

This is a spreadsheet formula not appsheet formula

(Marlon Xavier Medina Cisneros) #3

@Cubyl yes it is, but, Can I apply it to appsheet?

(Cubyl) #4

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

(Cubyl) #5

You need to use ; not ,

(Praveen Seshadri (AppSheet)) #6

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.

(Marlon Xavier Medina Cisneros) #7

@praveen ok, If you say that it is possible, the it is possible, thanks. If there is a sample app that use something silir please let me know, thanks in advance