Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am creating a URL for a specific field in Straight table through add link and then pasting the URL.
I have a requirement wherein I am suppose to represent 3 different links for that specific field like : If I have a field called ID so if(ID =1,'https://abc.com',
If(ID =2,'https://qwe.com,'https://asd.com'))
Can I add multiple links like this by using If?
Any advise will be great help!
I don't see why not, assuming each cell has a single URL associated with it.
Got it sorted
=If(WildMatch(ID,'QW*'),'https://www.yahoo.com',
if(WildMatch(ID,'A*'),'https://www.google.com','wikipedia.com'))
I don't see why not, assuming each cell has a single URL associated with it.
Yes, but IF doesnot work in this. Any other way ?
So 3 different links for 3 IDs but same field.
That doesn't look like a valid if() statement.
Sorry , I corrected it ,Thanks. That works.
But what in case if I have string values
Can you please help me with this , like using wildmatch and then the links
Same thing, just a different If() statement. It doesn't matter if the ID is numeric or string, and it doesn't matter if you use ID = 1 or Match(ID,1).
Actually I have something like this
ABC124
ABC345
BCV111
BCV567
QWERTY900
QWERTY220
so for
Got it sorted
=If(WildMatch(ID,'QW*'),'https://www.yahoo.com',
if(WildMatch(ID,'A*'),'https://www.google.com','wikipedia.com'))