Search code examples
google-sheetsgoogle-sheets-formulasparklines

"Formula analysis error" with Sparkline function in Google Sheets


I am coming here tonight because I do not understand something about Google Sheets.

I found a super GSheet file that can do Gantt planning. So I tried to transpose that into a personal document. Before starting to make some more custom formulas I just tried to copy and paste the formula used for the reference graph ("hatched" graph) and I already have a formula analysis error.

I really do not understand where the problem comes from.

Here is the original formula, functional:

Formula of origin, functional

And now the same formula in my doc, but that does not work

The same formula in my doc, does not work


Solution

  • try:

    =SPARKLINE({SPLIT(REPT("7,";FLOOR((INT(G5)-INT(F5))/7));",")\MOD(INT(G5)-INT(F5);7)};
     {"charttype"\"bar";"color1"\"white";"color2"\"lightgrey"})
    

    0