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.
1 Like
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:
4 Likes
this is brilliant, thank you!!!
1 Like