Sometimes in tables I want to put a
Blank value in place if there is not a proper value that should go there.
For example, here is an example inventory table that says when our product arrived, but if the product has yet to arrive I just want to have Blank in the table. Blank is nice because it is generally not considered in math formulas (like Sum, Average, etc.).
Right now, my hacky way of doing that is with
Last(List()) since Last returns Blank if the List is empty (so does First, but
First(List()) doesn’t have the same ring to it).
There is currently no
Blank() formula, but is there a better (more transparent) way to do this right now?
It would be really nice if by default when an
If() formula is filled out and one of the parameters is omitted it just returned
Blank (perhaps it could automatically fill in
Blank() for transparency sake)