Google Sheet formulea for making all the triage links which feed the template

Triage Queries

Template

=CONCATENATE("{{TriageLeads", CHAR(10), "|product=", A2, char(10), "|component=", B2, char(10), "|lead=[mailto:", D2, " ", D2, "]", char(10), "|backup=", char(10), "|toolurl=", F2, char(10), "|untriaged=", G2, char(10), "|needinfo=", H2, char(10), "|reviews=", I2, char(10), "|needdecision=", J2, char(10), "|needrange=", K2, char(10), "}}")

Bugs to Triage

=HYPERLINK(CONCATENATE("https://bugzilla.mozilla.org/buglist.cgi?product=", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, " ", "%20"), ":", "%3A"), "&", "%26"), "&component=", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2, " ", "%20"), ":", "%3A"), "&", "%26"), "&priority=--&n1=1&f1=flagtypes.name&o1=substring&v1=needinfo&resolution=---&chfield=%5BBug+creation%5D&chfieldto=Now&query_format=advanced&chfieldfrom=2016-06-01"))

Stale Needinfos

=HYPERLINK(CONCATENATE("https://bugzilla.mozilla.org/buglist.cgi?product=", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, " ", "%20"), ":", "%3A"), "&", "%26"), "&component=", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2, " ", "%20"), ":", "%3A"), "&", "%26"), "&f1=flagtypes.name&o1=substring&v1=needinfo&f2=delta_ts&o2=lessthan&v2=14d&resolution=---&query_format=advanced"))

Stale Review Requests

=HYPERLINK(CONCATENATE("https://bugzilla.mozilla.org/buglist.cgi?product=", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, " ", "%20"), ":", "%3A"), "&", "%26"), "&component=", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2, " ", "%20"), ":", "%3A"), "&", "%26"), "&f1=flagtypes.name&o1=regexp&v1=%28review%7Csuperreview%7Cui-review%7Cfeedback%7Ca11y-review%29%5C%3F&resolution=---&f2=delta_ts&o2=lessthan&v2=5d&query_format=advanced"))

Bugs that Need a Decision for a Train

=HYPERLINK(CONCATENATE("https://bugzilla.mozilla.org/buglist.cgi?product=", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, " ", "%20"), ":", "%3A"), "&", "%26"), "&component=", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2, " ", "%20"), ":", "%3A"), "&", "%26"), "&keywords=regression&keywords_type=allwords&v1=affected%2Cunaffected%2Cfixed%2Cverified%2Cdisabled%2Cverified%20disabled%2Cwontfix%2Cfix-optional&chfieldto=Now&o1=nowords&chfield=%5BBug%20creation%5D&chfieldfrom=2016-03-08&f1=cf_status_firefox48&resolution=---&query_format=advanced"))

Bugs that don't have a clear regression range
=HYPERLINK(CONCATENATE("https://bugzilla.mozilla.org/buglist.cgi?product=", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, " ", "%20"), ":", "%3A"), "&", "%26"), "&component=", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2, " ", "%20"), ":", "%3A"), "&", "%26"), "&j_top=OR&o5=nowords&f10=OP&keywords=regression%2C&keywords_type=allwords&f1=OP&v6=affected%2Cunaffected%2Cfixed%2Cverified%2Cdisabled%2Cverified%20disabled%2Cwontfix%2Cfix-optional&o7=nowords&f8=CP&v11=no&o11=equals&j10=OR&columnlist=opendate%2Creporter%2Cproduct%2Ccomponent%2Cstatus_whiteboard%2Ckeywords%2Cassigned_to%2Cbug_status%2Cflagtypes.name%2Cresolution%2Cpriority%2Cshort_desc%2Cchangeddate%2Ccf_status_firefox48%2Ccf_status_firefox49%2Ccf_status_firefox50%2Ccf_has_regression_range&resolution=---&f13=CP&o2=substring&o6=nowords&v7=affected%2Cunaffected%2Cfixed%2Cverified%2Cdisabled%2Cverified%20disabled%2Cwontfix%2Cfix-optional&f4=OP&chfieldto=Now&v5=affected%2Cunaffected%2Cfixed%2Cverified%2Cdisabled%2Cverified%20disabled%2Cwontfix%2Cfix-optional&query_format=advanced&chfield=%5BBug%20creation%5D&f12=cf_has_regression_range&chfieldfrom=2016-03-08&f3=CP&f2=keywords&v12=---&f11=cf_has_regression_range&o12=equals&f5=cf_status_firefox48&f6=cf_status_firefox49&v2=regressionwindow-wanted&f7=cf_status_firefox50"))