Format Formula LAMBDA Function

FormatFormula.lambda

/*
Name:  Format Formula (FormatFormula)
Description:  Uses OA Robot formula formatting api to format a formula to make it easier to read.
Parameters:
   CellOrFormula - Reference to cell containing a formula or a formula as text
   Compact - True to remove all whitespace (default: False)
Source:  @ExcelRobot, https://www.oarobot.com
*/
FormatFormula = LAMBDA(CellOrFormula, [Compact], LET(
   \\LambdaName, "FormatFormula",
   \\CommandName, "Format Formula",
   \\Description, "Uses OA Robot formula formatting api to format a formula to make it easier to read.",
   \\Parameters, {
      "CellOrFormula","Reference to cell containing a formula or a formula as text";
      "Compact", "True to remove all whitespace (default: False)"
   },
   \\Source, "@ExcelRobot, https://www.oarobot.com",   
   _Formula, IF(
      IFERROR(ISFORMULA(CellOrFormula), FALSE),
      FORMULATEXT(CellOrFormula),
      CellOrFormula
   ),
   _JoinWaitListAt, "oarobot.com",
   _FormatFormulaURL, "https://api." & _JoinWaitListAt & "/api/format",
   _QueryParameter, "formula=" & ENCODEURL(_Formula) & if(Compact,"&compact=true",""),
   _FormattedFormula, WEBSERVICE(_FormatFormulaURL & "?" & _QueryParameter),
   _FormattedFormula
));