I want FieldB to autoenter "n/a" whenever FieldA changes, regardless of what it changes to.

Thought I'd do this with Evaluate.

So I gave FieldB the calculation

Evaluate("n/a";[FieldA])

The result I get is usually "?" in FieldB. Though I seem to recall getting a "0" once and a "1" once.

So... I'm obviously not clear on the Evaluate concept.

Advice?

Hi

use this calc as auto-enter/replace of fieldB:

Case(

not IsEmpty ( fieldA );"n/a";

""

)

The reason why this is not working is that Evaluate() tries to evaluate the string "n/a" as a formula. What you wanted is:

Evaluate ( Quote ("n/a") ; FieldA )

A simpler way to achieve the same result would be:

Let ( trigger = FieldA ; "n/a")

Thanks. The Case (actually I did it as an If) approach is what I ended up putting in the other day temporarily and it works well enough, but I was interested in understanding Evaluate better.

I like the brevity of the Let calculation. Thanks for that.

Anybody know of a good thread or other place to read up on all the ins and outs of Evaluate? I did some searching here but haven't used the magic keyword combination yet apparently. Not finding much.