Goal: Display MAX (greatest) current result from column which keeps growing
Current issue: I can have all current entries regarded, however a newer, higher value gets ignored.
Attempts to set up :
=(MAX(NAME OF COLUMN)) Returns !.
=(MAX(Cell_1:Last_cell)) returns all existing values and ignores the new ones.
Also changed: All cells refer to decimal numbers with 2 digits.
What do I have to do to make the formula work?
Frustratingly enough I am working with an Apple template and have copied 1:1 the format that they use…