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.
Hello, Trying to do a count and this formula is working for all other number ranges, except for this one. Any ideas? Formula is this: =COUNTIFS([Risk Issue Factor Priority]:[Risk Issue Factor Priority], ">0", [Risk Issue Factor Priority]:[Risk Issue Factor Priority], "<7", Status:Status, "<>Complete", Status:Status,…
I am working on putting performance evaluations into Smartsheet. We have a set of criteria that employees will be rated on, and below is our scoring scale. Scoring Scale 5 - Exceptional: Consistently exceeds expectations; demonstrates leadership or innovation in this area. 4 - Strong: Frequently exceeds expectations;…
Is there any way I can create a column formula that pulls from a parent row? "For need formula here" I need to divide the value and cost from the parent row then multiply the value in the child row. I will be having multiple parent rows so I was hoping to have a column formula
