how to create a clickable text hyperlink to a google form or google sheet

(updated to remove live links from the formulas above as they caused it not to display correctly)

What you have now under TASK ID in the table:
HYPERLINK(“JKD Checklist LOOKER”,Task ID)

What you need instead:
HYPERLINK(CONCAT(“JKD Checklist LOOKER”,Task ID), “Click Here”)

1 Like