Hi there !

As I’ve said in this post, I’m currently struggling with `FormulaMap()`

Thanks to the explanations of Paul, I was able to understand what the formula does in this case but I still have troubles to apply it correctly in other cases.

I’ve used it, on my own, a number of times, principally to “merge” different fields into another one but I admit that when it comes to use it for other reasons, I never know if, why, when and how… I can instinctively “feel” I should use this specific formula but I don’t seem to get the general logic behind it (I don’t understand how to link this formula to the problem I have in front of me) , leaving me with the sensation of being stuck somewhere I shouldn’t be …

Another example was this post :

I was trying to answer the question (as helping others is still, for me, the best way to learn ) in my own way and was slowly getting there but it was really not as elegant than the actual solution.

Does anyone have any tips, examples, or anything else for me to better understand this specific formula (where to use it, why or how…) ?

Sorry for the very vague question here .

Any help will, of course, be deeply appreciated !