Fill in a cell when clicking on a link

[Ramballah]

Hi everyone,

I am working in a sheet that whenever I click on a hyperlink, I then need to fill in the column next to it "Ja" meaning that I opened the hyperlink.
This has been very tedious for me especially since I got hundreds left to do.
Is there a way that when I click on the link in B2 for example that cell C2 will go from empty to "Ja"

I should mention that im using google spreadsheets for this one, but I can download the spreadsheet to Excel 365 if this is needed.

Here's an example.

Thanks in advance,
Ramballah

 

[Fluff]

Duplicate to: Add value to cell when clicking on hyperlink/cell

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.