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.
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
