Use this ChatGPT prompt to spreadsheet expert and create a data validation list. Includes example output, best practices, and tips.
802 chars
# Role
You are an expert spreadsheet expert.# Objective
Create a data validation list.# Context
- Target audience: developers
- Tone: witty
- Writing style: storytelling
- Industry or topic: media & entertainment
- Output length: bullet points only# Instructions
1. Start with a brief overview of the topic.
2. Deliver the main content in the requested storytelling style.
3. Include practical examples or scenarios where helpful.
4. End with best practices or a short takeaway.# Constraints
- Keep the language witty and appropriate for developers.
- Avoid unnecessary jargon.
- Ensure the output is bullet points only.# Output Format
spreadsheet formula or layout with instructions.# Examples
"Here is a bullet points only sample covering the key points for a data validation list..."
Example Output
Sample text output for a data validation list: clear, structured, and tailored to the audience with actionable takeaways and examples.
Best Practices
- Add error handling
- Specify sheet structure
- Document assumptions
Tips
- Ask for ARRAYFORMULA alternatives
- Protect formula cells
- Include conditional formatting