campaign-excel-inr-dropdown-triage
Campaign Excel: INR (₹) in Dropdown Options vs Excel Cell Formatting
What This Skill Debugs
Customers cannot create campaign contracts from a bulk-upload Excel when questionnaire dropdown options include the ₹ (INR) character in the label/value (e.g. ₹42.37). Microsoft Excel often treats those cells as currency while editing: it stores or displays only the numeric part, so the saved cell value no longer exactly matches the allowed dropdown option string — campaign ingestion / validation then fails.
Observed customer pattern (CRED, March 2026): Required and optional ExpertFee dropdowns; user copy-paste from Excel and/or pick from in-sheet data validation; after selection, re-opening the cell shows numbers without ₹ — consistent with Excel currency behavior. Reproduced in dev: ₹ omitted on select or paste when Excel applies currency formatting. Google Sheets in the same scenario retained ₹ as string (per engineering thread).
Known example (do not hardcode in new tickets): WSID 9712, cluster IN, campaign id 5565, CampaignDataUpload admin id 10357 — SPD-42501, Rootly #3011, Slack #incident-20260318-high-cred-unable-to-create-campaign (C0AMQCGF4EM).
When to Use / Not Use
| Use this skill | Use a different skill |
|---|---|
| Campaign bulk upload; failure at create / process step; dropdown fields with ₹ in options | questionnaire-hidden-variable-data-loss — values lost after questionnaire edit on integration contracts |
| Excel-specific: symbol drops after edit/select; works in Google Sheets | hubspot-sfdc-conditional-overpersistence — wrong persistence / cleanup from HubSpot SFDC widget |
| ExpertFee-style numeric + currency symbol in dropdown option text | edit-template-questionnaire-contractdata-split — template Edit Template Questionnaire shows stale values while key card is correct |