Tool #2: Parse Error at char(0): Unknown variable "E" (expression #1)

BRRLL99

I have connected 6 different List box tools and updated the formula with in Action Tool

When I placed the Macro in the Data

I'm receiving this error

can someone help me to decode the error

Data Investigation

Accepted answers

FinnCharlton

@BRRLL99 for this issue, the best way might be to get rid of the action tool altogether. You can link the list boxes directly to the "Q" anchor of the formula tool (see below). Then, replace the formula with the one currently in your action tool.

All comments

FinnCharlton

Hi @BRRLL99 , is Tool #2 the formula tool you are changing? It looks to me like there is something going wrong with your Action tool configuration, leading to the formula being updated to an invalid one.

Some screenshots of your action tool configuration and your formula tool would be useful.

BRRLL99

this is the formula I have written in Action tool

FinnCharlton

BRRLL99

Please share the workflow

BRRLL99

could please let me know the reason

Why action tool was removed?

FinnCharlton

@BRRLL99 , you had already written a formula that dynamically updates when the list box values change. The formula tool can deal with this directly, without an action tool inbetween.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703