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:
And now the same formula in my doc, but that does not work
try:
=SPARKLINE({SPLIT(REPT("7,";FLOOR((INT(G5)-INT(F5))/7));",")\MOD(INT(G5)-INT(F5);7)};
{"charttype"\"bar";"color1"\"white";"color2"\"lightgrey"})