google sheets
I'm treating a google sheet as a crude DB in which to dump details of all items in an issue-tracker (GitHub). A user can then add manual data in additional columns which must not get overwritten.
I want to set up different views e.g. one shows only open issues, one shows only bugs, etc.
It looks like Filter Views are the answer here but can I get an explicit URL to each one, to avoid my user having to figure them out? e.g. I can just say "this is the bug list URL"?
Have an additional column, "flag" (leave it blank). Now, in your onEdit event:
SpreadsheetApp.getActiveSheet().getDataRange().getValues())Now, for each row, do the following:
Find the email cell in that row (you know the column number), send the emails
That's it :)
You added single quotes to the sheet references:
=ListBy('sheet1'!A1:A10, 'sheet1'!A1:A10, "needle")
If you leave those:
=ListBy(Sheet1!A1:A10, Sheet1!A1:A10, "needle")
then your script works as planned.
Sheet2:
Sheet1:
Best Answer
You can use
=QUERYto filter on your range and pull out only the OPEN Issues.You can share the URL with the link that goes straight to your 'OPEN' page.
Formula Used:
Sheet 1 - Master Sheet
Sheet 2 - Open Issues.