anyway to create formula for matching current user to cell contact list value

I've tried multiple things, even making them select a dropdown on the top row so the "modified by" for that row captures their name then using another column with contact list property with the formula "=[modified by]@row" for the remaining rows.
But even this fails since in the "standard" contact list dropdown my name appears as RN Richard Normandin, whereas when it looks it up by my email from the "modified by" column it comes up with R Richard Normandin, so you cannot use a match, has, if, or other function or formula to compare them.
Answers
-
Depending on the number of users and how many have fairly similar last names and such, you could use something like a find @cell with just the right 10 characters of the modified by column…
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!