0

The solution outlined here is ideal for my needs (converting an article ID in column C into a hyperlink to a CMS that displays in column D).

However, I would like the formula to leave column D blank if the adjacent cell in column C is blank.

My current function is...

=HYPERLINK(CONCATENATE("https://WEBSITECMS.COM?post=",C228,"&action=edit"),C228
)

What would be the best way to go about this?

Screenshot of Google Sheets hyperlinks created from data inserted into cell

Jack_Luke
  • 3
  • 2

1 Answers1

0

You could wrap it into IF: if C228 is blank, then remain blank, if it isn't it should create the HYPERLINK:

=IF(C228="","",HYPERLINK(CONCATENATE("https://WEBSITECMS.COM?post=",C228,"&action=edit"),C228))
Martín
  • 1,426
  • 2
  • 4
  • 7