sheets_filter_formula
Google Sheets FILTER formula
Build a FILTER formula that shows the rows of a range matching 1-3 conditions (equals, contains, starts/ends with, one of, blank, number and date comparisons), optionally sorted and with a "no match" message. Returns the formula and a note.
Parametersjoinorderrangerequiredseparatorconditionsrequiredskip_blankscase_sensitivecells_are_textno_match_message
sheets_rank_formula
Google Sheets RANK formula
Build a formula that ranks one column, with a choice of tie handling (min: 1,2,2,4; dense: 1,2,2,3; avg: 1,2.5,2.5,4; unique: 1,2,3,4) and optional ranking within a group column. mode "column" fills the whole column from one cell; mode "row" is a per-row formula to drag down.
Parametersmodetiesgrouprangerequireddirectionseparator
sheets_unique_formula
Google Sheets unique values formula
Build a formula for unique values: a UNIQUE list, COUNTUNIQUE, a value/count table, only the repeated values, or only the values that appear once.
Parametersmodeorderrangerequiredseparatorignore_caseskip_blanks
docs_match_case_replacement
Replace keeping the case of each match
Given matched texts and a replacement, return the replacement in the case shape of each match (ALL CAPS, Title Case, First letter, lower). The rule ReplaceKit uses for "Keep the case of each match" in Google Docs.
Parametersmatchesrequiredreplacementrequired
clean_text
Clean pasted text (spaces, breaks, quotes)
Run ReplaceKit cleanups on text (up to 50,000 characters), in the order given: double-spaces, space-before-punct, trailing-spaces, empty-paragraphs, line-breaks, nbsp, curly-quotes, straight-quotes. Returns the cleaned text and how many replacements each made.
Parameterstextrequiredcleanupsrequired