Formula Tool triggers variable error when publishing but works fine when run on Server

[aehrenwo]

I have an odd error message that is happening after an XML parse where the Formula tool is saying a field/variable is unknown. However, when I run the workflow on the server directly, it runs without error messages. 

We recently upgraded to 2022.1, so not sure if that has anything to do with this "bug". Should I just try creating the workflow from scratch or add and remove the formula tool and see if that fixes anything? 

[jrgo]

Likely a moot error that is common when using tools that create the columns at runtime. In your case, the field your formula is looking for is created from your XML tool. When Gallery runs it's validation test, it executes a 0 record run and since there's no records it's actually processing, the XML tool is not generating the field that downstream tools are expecting.