Google Sheets: Link from one sheet to another and pass a variable to that sheet
Budget: €8 – €30 EUR
I have 2 google sheets:
Clients: a list of clients along with their email addresses
Report: a report which when a client email is selected from a dropdown shows a particular clients data.
I want the functionality to click on a link in the Clients sheet for a particular client which then opens the Report sheet and displays the report for that client (populates the email address in the dropdown with that clients email)
Clients: a list of clients along with their email addresses
Report: a report which when a client email is selected from a dropdown shows a particular clients data.
I want the functionality to click on a link in the Clients sheet for a particular client which then opens the Report sheet and displays the report for that client (populates the email address in the dropdown with that clients email)