Is it possible to have a calculated column display data from one
column but use data from another?
I would like to have one single column that displays the name but when
clicked, uses the E-mail link to open our e-mail client and I would
like to accomplish it with minimal exertion.
Column 1 | Column 2
Name | E-Mail address (linked)
Combined Column
Name (that is an email link)
And if that can't be done, I'd like to know if there is some sort of
carriage return formula I could use in a Calculated column that would
display Column 2 right below Column 1 on one row:
Name
E-Mail