What Should I Be Using For If(Value.isNotBlank(), ..., _NoOp())

[cnr]

I guess I’ve asked about this before on my other account a couple times, haha.

Add an IfNotBlank() formula

There is no IfNotBlank() formula. Which is a problem because IfBlank().Not() does not have the same functionality as IfBlank(). X.IfBlank(value) will return value if X is blank. X.IfBlank().Not(value) is just an error.

`IfBlank` should allow three arguments (the third would be `if not blank do this`)

Sometimes a formula will try to access an attribute that doesn’t exist: [image] When this happens, it can wreak havoc on a series of in doc variables by turning them all into [image] error symbols. Even attempts to manually override the behavior doesn’t fix the issue: If(applicableManualResets.IsBlank(), false, [...] applicableManualReset.[Reset Time] [...]) Still results in a [image] symbol because applicableManualReset doesn’t have a [Reset Time] column right now, but it will once cert…