SchedulingDifficulty: Beginner

Shift roster formula builder

Describe your roster rules in plain words and get the spreadsheet formulas, where they go and tests to check them.

Use this when you build a shift roster in a spreadsheet and need formulas that follow your rules, instead of testing formulas by trial and error.

Skip this if you want formulas written straight into your live sheet, or you will not test them first.

From the story, as claimed A Thai data entry officer used Copilot to build the formulas for a 200 person shift roster and cut three days of work to 30 minutes

Works with
Microsoft Copilot, Claude, ChatGPT, Gemini, Any AI chat The story used Microsoft Copilot with Excel. Any AI chat can write the formulas for you to paste in. Say whether you use Excel or Google Sheets.
Tools in the story
Microsoft Copilot
Country
Thailand
Show skill

If the Copy button does not work, select this text and copy it.