Back to guide/General Productivity

Dashboard Formula Set

Using Excel Table names produces formulas that auto-expand with new data. Asking for dynamic formulas prevents dashboards that break when the dataset grows.

chatgpt-prompts-for-exceldata_sheet_namedescribe_columnsmetric_1
Edit View
Prompt
I'm building an Excel dashboard. Help me create the summary formulas.

**Data sheet:** "{{data_sheet_name}}" with columns:
{{describe_columns}}

**Dashboard metrics I need:**
1. {{metric_1}} (e.g., "Total revenue this month")
2. {{metric_2}} (e.g., "Top 5 products by units sold")
3. {{metric_3}} (e.g., "Month-over-month growth %")
4. {{metric_4}} (e.g., "Count of orders by status")

For each metric, provide:
- The formula (using SUMIFS, COUNTIFS, LARGE, INDEX-MATCH, etc.)
- Where to place it on the dashboard sheet
- How to make it dynamic (auto-update when new data is added)

Use named ranges or structured table references where appropriate. My data is in an Excel Table named "{{table_name}}".

Variables to customize

{{data_sheet_name}}{{describe_columns}}{{metric_1}}{{metric_2}}{{metric_3}}{{metric_4}}{{table_name}}

Why this prompt works

Using Excel Table names produces formulas that auto-expand with new data. Asking for dynamic formulas prevents dashboards that break when the dataset grows.

Save this prompt to your library

Organize, version, and access your best prompts across ChatGPT, Claude, and Cursor.

Related prompts

Task Decomposition Agent

Forcing the agent to plan before acting prevents premature execution and wasted steps. Explicit dependency mapping enables parallel execution and catches logical gaps early.

Tool Selection Agent

The ReAct pattern (Reason + Act) creates an explicit reasoning trace that improves tool selection accuracy. The error-handling rule prevents infinite retry loops.

Prompt Compressor

Explicitly requiring all functional requirements to be preserved prevents the model from over-compressing and losing critical instructions.

Memory Management Agent

Explicit memory read/write instructions create agents that improve over time. Categorization keeps memories organized, and the deduplication rule prevents context bloat.