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 SmartSheet Community. I have created a report with various categories and totals. I wanted to capture certain categories and their totals however the totals are not calculating correctly. I would have to copy the totals, paste them to an excel blank sheet and AutoSum there. Can someone see what I am doing wrong?…
I need help creating a formula to calculate how many hours my team is allocated for per week. I have three columns in my sheet that we use for task management. Hrs per week - is a number on the hours it takes Assigned to - is a manual text field of the team member who is doing the task Due Date - when it is due (typically…
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
