Shifts schedule export to Excel has problems ...

%3CLINGO-SUB%20id%3D%22lingo-sub-2562288%22%20slang%3D%22en-US%22%3EShifts%20schedule%20export%20to%20Excel%20has%20problems%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2562288%22%20slang%3D%22en-US%22%3E%3CUL%3E%3CLI%3E%3CP%3EIf%20exporting%20simply%20(not%20clicking%20on%20%22file%20that%20can%20be%20imported)%2C%20then%20Shift%20notes%20do%20not%20appear%20as%20a%20column.%20You%20have%20to%20doubt-click%20the%20column%20in%20Excel%20with%20the%20shift%20reveal%20the%20shift%20note.%20Also%2C%20even%20if%20you%20uncheck%20daily%20hours%20and%20time%20off%2C%20it%20still%20exports%20them.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EIf%20you%20export%20with%20%22file%20that%20can%20be%20imported%22%20you%20lose%20cell%20shading%20colors%20(it%20becomes%20a%20column%20with%20the%20color%20written%20out)%20and%20each%20employee%20could%20have%20two%20or%20three%20rows%20if%20there%20is%20a%20shift%20note%20%26nbsp%3Badded.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EExporting%20to%20excel%20and%20then%20dropping%20into%20Slack%20loses%20spreadsheet%20presentation%20and%20puts%20each%20column%20on%20its%20own%20page.%20Quite%20a%20mess.%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2562288%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
  • If exporting simply (not clicking on "file that can be imported), then Shift notes do not appear as a column. You have to doubt-click the column in Excel with the shift reveal the shift note. Also, even if you uncheck daily hours and time off, it still exports them.

  • If you export with "file that can be imported" you lose cell shading colors (it becomes a column with the color written out) and each employee could have two or three rows if there is a shift note  added.

  • Exporting to excel and then dropping into Slack loses spreadsheet presentation and puts each column on its own page. Quite a mess.

0 Replies