So, this formula will work when it comes to the format of the URL you provided.
If the Spotify URLs you’re working with are always in that format, then this formula will work fine.
Now, if you’re dealing with different formats, then you’re going to run into problems, as the formula I provided has a hard-coded value that removes the entire
https://open.spotify.com/playlist/ from the string.
From there, the formula just extracts every alpha-numeric character sequentially, which means it will always stop at the ? in the remaining string.
Truth be told, I’m not the fondest of this formula since it doesn’t work for different URL formats, but I’m merely human.
Let me know if you have more complex requirements, and we can definitely go from there.