N() is a google sheets function, what is the equivalent in appsheet?
I want to compare a column of [START time] (type TIME) with TIMENOW() function, but it doesnโt work.
In sheets I get it to work by getting the serial number of the [START time] with N() and that allows me the operations I need.
https://support.google.com/docs/answer/3093357?hl=en
There is no exact equivalent. But you could try NUMBER() or, maybe EXTRACTNUMBERS()
How doesnโt it work? What exactly did you try?
What is a โserial numberโ of a Time value?
Why??? Even in Sheets, thatโs a complex solution to a simple problem. Times can be compared directly.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |