A tip for struggling users: copy paste

Just sharing a tip … it seems the visual builder is really fragile in regards to building out spreadsheet type formulas. This is strange to me because basic error correction seems like it would be extremely easy to implement. Regardless, if you find that steps simply don’t work when they should I’ve found copying the formula and pasting it into a TEXT editor (not a word processing program) often reveals 3x quotes when there should be 1x and so on. Edit in the edit editor and then paste back into Make. Often that will get it working.

A variable in make step will look similar to this in your text doc:


The editor is meant for very simple constructions I believe. Thus the length is usually quite small. But your tip is crucial for editing complex formulas as long as you know the formatting. Once you paste it back in the parser will show you can errors quickly.