I'm importing an Excel spreadsheet into Google Drive. Its a huge spreadsheet, and overall Google spreadsheets has converted everything, except the following:
There are a few cells with formulas like this:
Where among the many sheets, some are named
Sun-D. But it isn't working - instead I have the error
Error: Unresolved sheet name 'Mon-D:Sun-D'.
So the next thing I did was wrap the names in quotes as I thought maybe it was getting confused:
But both give me
Error: Formula parse error. I'm not very familiar with Excel, or Google Drive - what am I doing wrong? I'm guessing I need to separate the sheet names more clearly somehow.