Sign in to join the conversation:
Hi,
I'm not able to use the email adress of a contact in another cell.
I need this for building a specific link in another cell. e.g. https://blabla.com/#browse/profile/john.doe@gmail.com
="https://blabla.com/#browse/profile/" + contact2 will not work :-(, it returns the name of the contact.
Any idea how to get this working?
Hi Joachim,
When you create a reference an individual cell —the surface value is returned. If you're goal is to return the email address, then the email address must be the surface value.
Depending on the number or email addresses you're working with, you may want to consider either editing the Contact List properties so that it only contains only email addresses in the preferred values text box —or— you could create a new column (with only email addresses in the preferred values text box), reference the cells in this column in your formula, and hide it if needed.
As a basic outline, I have column 1, 2, and 3. Columns 1 and 2 list 4 identical options: A, B, C, D in a drop down menu. Essentially, I would like column 3 to calculate/display the difference between columns 1 and 2, removing a duplicate. For example: Column 1: A, B, C, and D are selected in the drop down Column 2: B is…
I need the formula to get the text from the next row in a specified column. I am creating the formula in row 2 in a column named 'Next' and want it to bring back the data from column 'Test' in row 3. This is what I have tried so far but getting #unparseable error. =INDEX(Test:Test, row() , +1) =INDEX([Test]:[Test], row() ,…
I have a formula that is currently working (see below); I need to add a condition, from a specific Column (Study Status)-that if it equals a particular choice ("Study Ongoing - Follow up"), that it doesn't even bother looking at this formula and automatically turns the FLAG off. Furthermore, I'll need to have several…
