Ternary operator

Hi,

Usage example:

INDEX(SELECT(...), 1) || 0

This would have the same result as:

IF(ISBLANK(INDEX(SELECT(...), 1)), 0, INDEX(SELECT(...), 1))

It would be much clearer and possibly a performance gain as you could exec one query instead of two.

I thought about posting this exact request a week or so ago. But instead I posted the following one. The reason being that Appsheet generally follows spreadsheet-esque formulas, instead of coding language type syntax. I don’t believe any spreadsheet systems have a ternary operator (but would happily be proven wrong), but they do have IFERROR().

3 Likes

https://www.google.com/search?q=ternary+operator

3 Likes