I use a simple chaining of formulas and three tables. Step 1-2 is the combination of Step1 and Step 2 in a single formula, but it fails to compute. Seems like the type checker is lost, and the run engine as well. See the reproduced bug here:
Hi @Mikael_Mayer ,
the problem relies on a wrong lookup reference in
History in your
You set it as
Options, but is in fact is
Once fixed, you should be able to make it work.
Also in the Table 1 column, it should:
thisRow.History.[Contacted via].CountIf(CurrentValue = Videoconference)
I hope it helps.
Weird! I did not know that the column type would influence runtime semantics.
Thanks for pointing this out.
Maybe it infers the data type if it’s not specified (try with a generic Text).
But if you explicitly set it, it will treat the data accordingly.
Happy it worked: enjoy!