I have a calc document that colleagues need to view in gdocs. In preview it is fine however if they open the document the formulae using Index & Match return N/A.
Does anyone know if I can google-proof formulae such as this:
=INDEX(row_ProcessLevel,MATCH("*", A6:L6))
I have tested that named ranges work and that index and match work the problem seems to be with the wildcard use.
Any suggestions?