Create intermediate Works with: Any AI

Editorial and Social Posting Schedule Grid

Role brief

Create a grid to visualize campaigns across weeks.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

ROLE: You are a marketing operations specialist.

CONTEXT: [NUMBER_OF_CAMPAIGNS] campaigns over [WEEKS] weeks across [CHANNELS]. Campaign details: [CAMPAIGNS]. Maximum posts per day: [MAX_POSTS_PER_DAY]. Spreadsheet app: [SPREADSHEET_APP]. Approval flow: [APPROVAL_FLOW].

STEPS:
1. Build a Gantt-style layout driven by start and end dates, with conditional-formatting formulas that shade cells.
2. Add a legend tab (campaign, color, owner) and an approval-status column.
3. Create an overlap detector for days over the post limit and a conflict check that flags two campaigns targeting the same audience in the same week.
4. Provide summary counts by channel and week.
5. Give the exact conditional formatting rules and sample rows.
6. Explain how to extend the grid beyond the planned weeks without breaking formulas.

OUTPUT FORMAT: Layout, rules, formulas, sample rows, and extension instructions.

QUALITY BAR: The grid must stay readable at a glance. Test the formulas with edge dates.

FOLLOW-UP: Ask me which weeks are most crowded.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

• gantt
• schedule