Forum Discussion
Hyperlink function returns "#value"
Thank you for the input! So by exceeding the total limit, is this all the text encapsulated in the link location portion for the hyperlink function? If so, how do you overcome this?
- As a side note, be careful with the amount of conditional formatting you are applying. the file could be come super slow.
Your table finishes at row 15,155 and then you have formatting all the way down to row 1MillionThank you for the advice!
Although, I'm still having trouble getting the help cells to work. If you look at the bottom of the spreadsheet for 1912038, I created two columns for the helper columns with the mail to and subject in column 1, and the cc and body for column 2. But when I copied the syntax you used to merge them, it was unsuccessful. I'm guessing the issue is still the character limit? If this is the case, the body portion is probably the issue.
Can you let me know how to proceed?
Thanks.
Yep, best option is to split the string into 2 helper columns and then join those in your hyperlink function
