3

Please use the following (Adjust ranges to your needs) =SORTN(QUERY({INDEX(ROW(D2:D)),D2:E}, "select Col2, Col3 where Col2 is not null order by Col2, Col1 desc"), 9^9,2,1,1) How the formula works We add a virtual column based on each row to our query and order the query. We then -in ...


3

You can use =INDEX(SPLIT(F22, " - "),,2) - INDEX(SPLIT(F22, " - "),,1) This means we split the same cell twice. Using INDEX we use the second column of the first split minus the first column of the second split. (Of course you should format the result as duration.)


1

The problem is that the onOpen function is incomplete; .addToUi(); is missing. This is the onOpen function on the referred guide /** * Creates a menu entry in the Google Docs UI when the document is opened. * This method is only used by the regular add-on, and is never called by * the mobile add-on version. * * @param {object} e The event parameter for ...


1

Regarding point 1, there aren't enough details but even proving all the possible relevant details its very likely that only Google can answer it. Regarding point 2, you don't need to see the formatting applied to a cell to apply it to another cell, use the Paint format tool.


1

Please use (Do adjust ranges to your needs) =ArrayFormula(IFERROR(VLOOKUP(G2:G, QUERY(SORTN(SORT({ROW(D2:D),D2:E},1,0),9^9,2,2,1), " select Col2, Col3 where Col2<>'' "),2,0))) How the formula works We create a virtual column based on each row, sort and query the result. We then use the VLOOKUP function ...


1

The currency format is not being applied because the values are text, not numbers. To fix this, there are several options: set IMPORTJSON to return numbers or to return formatted text. Use formulas to parse the values as the required type or to format them Copy/paste as value only, then if necessary remove blank spaces, etc.


Only top voted, non community-wiki answers of a minimum length are eligible