When trying to find out where exactly the issue is with a formula that does not give me the output it should, I like to test sub-parts of it to see what their output is. to do that I would love to copy-paste a sub-part into a test field. (without having to first paste the whole formula somewhere else to still have it and then delete the parts i dont want to test)
Hi there
Thank you for your feedback!
Would you mind creating a feedback ticket so our dev team can review it?
For formulas like these, where the complexity is high, I tend to use the JavaScript option, it lets you do the same, but more cleaner and you can test and run even per partes.
Or just being able to format the formula with spaces/tabspace like usual code would be nice, so we can visually break up the one-line-code
I agree with Boberto that javascript is generally better once it gets complex. But I do have a few formulas like this what I do to test is you can chuck a // in front of your current formula this essentially comments out that part and you add any little snippet you want in front of the // to test
Example:
this is brilliant, thank you!!!