data validation and using hyperlink to email

A

Anastassia

Hi there,
I am creating a spreadsheet that contains dates and places.
However the columns that contains dates, I have used a data validation pull
down box, so other users can make their selection.
I want to add a hyperlink to these columns so that when they click on the
date, they will be redirected to a new email message.
I have tried to use the hyperlink function and thought I was doing it right,
but for some reason the link isn't working after when I go back to that cell,
even though the date is highlighted blue and underlined.

can someone please tell me what I am missing???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top