Anyway Smartsheet can recognize the value in a cell as an email adreas and convert it to a hyperlink?
Based on value in a cell in Sheet 2, an email address is "pulled" from a cell in Sheet 1. However, its text, not an email address contact/hyperlink.
Ultimately, I need to have a way Smartsheet can use the email address to send an alert based on the value of another cell.
I enter course code in a cell in Sheet 2. A formula in another cell in Sheet 2 pulls email address from cell in Sheet 1. Another cell in Sheet 2 is updated as "on track" or "not on track. If set to later, an alert is automatically sent to the email address that they need to attend a weekly meeting to resolve an issue and get course back on track.
Thanks for any suggestions!!!