My problem is the following. We have a server migration soon and we have hardcoded the instance number in our email templates that point out to our Production environment (in this case NA44).
So in my case, I created a formula field that must be filled with the instance number. Say that the URL in question looks like this: https://neb--qa.cs69.my.salesforce.com
How can I get the "cs69" part that is the only thing that matters for me? I tried different formula combinations using the
$Api.Partner_Server_URL_140 merge field but I couldn't do it yet.