I've created a timesheet spreadsheet for our workers which they complete and return to us.
Not all of our workers have Excel, so are completing it in Google sheets.
When we get it back, it looks correct, until I clienk "Enable Editing", then it all goes awry.
Some of the formulas are changing to array formulas, which is generating errors throughout the spreadsheet.
I can go in and manually adjust them back to standard formulas, but this is time consuming.
An example of one of the formulas is below:
=IF(OR($B9="", $B9="Sub Total", OFFSET(INDEX(Import!$A:$G,MATCH("Shift Date:",Import!$A$1:$A$20,0),1),ROW()-8,0)="Shift Date:"), "",OFFSET(INDEX(Import!$A:$G,MATCH("Shift Date:",Import!$A$1:$A$20,0),1),ROW()-8,0))
Any ideas would be greatly appreciated.
Not all of our workers have Excel, so are completing it in Google sheets.
When we get it back, it looks correct, until I clienk "Enable Editing", then it all goes awry.
Some of the formulas are changing to array formulas, which is generating errors throughout the spreadsheet.
I can go in and manually adjust them back to standard formulas, but this is time consuming.
An example of one of the formulas is below:
=IF(OR($B9="", $B9="Sub Total", OFFSET(INDEX(Import!$A:$G,MATCH("Shift Date:",Import!$A$1:$A$20,0),1),ROW()-8,0)="Shift Date:"), "",OFFSET(INDEX(Import!$A:$G,MATCH("Shift Date:",Import!$A$1:$A$20,0),1),ROW()-8,0))
Any ideas would be greatly appreciated.