For those of you often sending Slack notifications or internal emails to slaes/others and working with SFDC, I'm sure you've been frsutrated with dynamtically pulling the lead vs contact ID into a link. Well I created a calculated/formula property today that solves this for me:
First, this checks to see if a contact has ever synced to SFDC, then it checks to see if there is a Contact ID, and if there is, it combines the values into a URL string. If there isn't a contact ID, it combines the Lead ID into a URL string. FYI, you have to include "/view" at the end of the URL, thus why there's a nested concatinate function.
Note that you will need to replace [your-company] with your SFDC URL/instance.