Active URL inside editable cell

Tagged: html, problem, URL

This topic has 3 replies, 3 voices, and was last updated 4 years, 10 months ago by neveryoung2212.

Viewing 4 posts - 1 through 4 (of 4 total)

Author
Posts
February 23, 2018 at 10:43 #16744

pariluck
Participant
Almost 2 weeks the developer is not answering my request regarding a possible bug.
This is a video: https://www.screencast.com/t/5Oi8HE2e
Is anyone here to help? Please help.
February 26, 2018 at 17:21 #16766

Alex_support
Member
Hello, @pariluck.
In google sheet, formula =CONCATENATE works the same – we don`t think we should fix it, but as a variant we can just add new formula =HTML to return content predetermined to it, removing all substitutes for html symbols.
Please, tell me about your thoughts on this issue.
March 1, 2018 at 14:53 #16776

pariluck
Participant
Hello
This is what we need:
Depending on the conditions we need to display the active link.
if [condition 1], then Link 1; else if [condition 2],
then Link 2; else if [condition 3], then <a
href=”#link3″>Link 3; else if [condition 4], then 4; else Link 5
OR
[condition 1]:
TRUE – Link 1
FALSE –
[condition 2]:
TRUE – Link 2
FALSE –
[condition 3]:
TRUE – Link 3
FALSE –
[condition 4]:
TRUE – Link 4
FALSE – Link 5
There are formulas we used in the test.
http://imageshack.com/i/pnexfTcLp – Choose A2 (Dropdown list)
http://imageshack.com/i/po7EWHItp – Test1; Formula in B2
http://imageshack.com/i/pmRZcLAOp – Test2; Formula in B3; C7, C8, 9 – contain Active Links
http://imageshack.com/i/pmV3jPTxp – Test3; Formula in B4; we try to activate link (formula in B2: =IF(A2=A7;B7;IF(A2=A8;B8;IF(A2=A9;B9;”Choose
Default”))))
http://imageshack.com/i/pn4pUpxUp – Test4; Formula in B5
May 16, 2018 at 16:29 #17597

neveryoung2212
Member
Hello, @pariluck
Sorry for a late reply on forum. As far as I know, your problem has been resolved.
Just in case everybody else will be looking for an answer here I’ll leave a conclusion – we have implemented it to life.
Author
Posts