1

I have a been using a Calendar which populates the Data in Calendar by matching the dates from the Event Sheet and it is working fine.

One thing i want that the formula it should create a hyperlink on the value which is populated in the calendar so when i click on the cell it take me to the concern row of the event sheet.

I have quoted two examples. Any help will be highly appreciated

=IFERROR(JOIN(CHAR(10),FILTER(Events!$B:$B,Events!$C:$C<=B5,Events!$D:$D>=B5)))

Examples: Hyperlink in Google Sheets and Gif

Google Sheet Link Google Sheets

1 Answers1

1

here is how you create jump link:

=HYPERLINK("#gid=1102623837", Sheet2!A2)

enter image description here

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124
  • thank you so there is no other way which can find the exact cell automatically via using formula/script. Because i have whole year calendar which changes by months and weekdays. If i apply this way i have to work manually a lot. –  Jun 04 '21 at 06:36