Is it possible to use the Mathematic Number such as a power likes " 5 squared" or “5 cubed” or “5 to the fourth power”? Thanks
Use POWER() function; here is the details from help center:
Power(numericX, numericY) returns a decimal that raises numericX to the power of numericY. For example, Power(4, 2) = 16. Power(16, 0.5) = 4.
Check out this link for more Math expressions: https://intercom.help/appsheet/expressions/expression-types/math-expressions
@RezaRaoofi Thanks, more question how can I show the Power number format on the app?
If you mean something like 2.3E6, or 2^4, there isn’t any straight forward formatting you could use; I would just put pieces together using CONCATENATE() function, or its equivalent operator which is & in syntax like this:
CONCATENATE(“text1”,"^",“text2”) or “text1” & “^” & “text2”
So the column type will
turn to text and the app could not use the compare expression. am I right?
I would use 2 columns; one numeric for using POWER() function, comparing expressions, and storing the number, etc., and a second column that could be Virtual Column for display purposes which would contain CONCATENATE function to build the particular format you are looking for.