I have a user with a Document Library called Submissions. Below is an excel example of what the user's library looks like with data:
The Display Name column is a Calculated Column. The user wants/insists to have the column Display Name to output in a format like Doe, John instead of John.doe.
Below is the setting the user had when this request was brought to my attention:
I told the user it was impossible to output as requested due to it pulling from Employee column and formula is just impossible to do so. I need a second opinion/technical response to further explain why it cannot be done. On the other hand, if I'm wrong and there is a way to output the calculated column Display Name to Doe, John can someone please show me how to do it?