Solved: how to create a clickable text hyperlink to a goog... - Page 2

Sanziiv · 09-27-2024 09:57 PM

i am making a looker studio task checklist report which is connected to google sheets named delegation sheet copy.

i have picked up the reports column from that delegation sheet. currently the columns are name t ask details and task done date and last task status column.

i need to create a task id and in next column "click here" hyperlinked text. the named assigned for any particular task person will click on that particular click here and then that will lead to a google form. there will show task id which will seen autofill. the person will have need to only click submit button and that task will be done.

so i need the hyperlink formula which creates task id column and clickable "click here" text. if task id column can't be created then provide only "click here" hyperlinked text formula.

https://lookerstudio.google.com/u/0/reporting/aa1da12f-3e56-47c0-b4de-8f437fbe551a/page/3CRDE/edit

lauratilton

(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("https://docs.google.com/forms/d/e/1FAIpQLSefpbzxbxQradF2ISMx79cZbhaI20IKszNQWsIxI_rBZZPUUw/viewform?usp=pp_url&entry.546974750=6588",Task ID)

What you need instead:
HYPERLINK(CONCAT("https://docs.google.com/forms/d/e/1FAIpQLSefpbzxbxQradF2ISMx79cZbhaI20IKszNQWsIxI_rBZZPUUw/viewform?usp=pp_url&entry.546974750=",Task ID), "Click Here")

View solution in original post

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