![Andrew_Enright Andrew_Enright](https://community.airtable.com/legacyfs/online/avatars/2X/c/c3e9cb64fc089a2b8552e74cbf6d81c5548422f9.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 18, 2016 06:03 PM
This may be obvious to many, but it eluded me until today…
It is a HELL OF A LOT easier to code (and debug) formulas in Textedit (or the text editor of your choice), inserting returns between segments (B).
When you paste your code into Airtable, it’ll smartly remove those returns and create the code block we’re used to seeing (A).
A
IF({Auto-Status} = “Awaiting Review”, “ :mag: ”,IF({Auto-Status} = “Complete”, “ :checkered_flag: ”,IF({Auto-Status} = “Design”, “ :art: ”,IF({Auto-Status} = “Released to Supplier”, “ :rocket: ”,IF({Auto-Status} = “On Our Radar”, “ :satellite: ”,IF({Auto-Status} = “Production”, “ :triangular_ruler: ”,IF({Auto-Status} = “Cancelled”, “ :skull: ”,IF({Auto-Status} = “On Hold”, “ :zzz: ”,IF({Auto-Status} = “Design Queue”, “ :art: :soon: ”,IF({Auto-Status} = “Content Needed”, “ :question: ”,IF({Auto-Status} = “Unassigned”, “ :busts_in_silhouette: ”,IF({Auto-Status} = “Design Route”, “ :art: :arrows_clockwise: ”,IF({Auto-Status} = “Copy”, “ :pencil2: ️”,IF({Auto-Status} = “Production Route”, “ :triangular_ruler: :arrows_clockwise: ”,IF({Auto-Status} = “Production Queue”, “ :triangular_ruler: :soon: ”,IF({Auto-Status} = “Retouching”, “ :nail_care: ”,IF({Auto-Status} = “Retouching Queue”, “ :nail_care: :soon: ”,IF({Auto-Status} = “Released by Production”, “ :airplane: ️”,""))))))))))))))))) & " “) & IF({Rush Request} = 1, “ :fire: ”,”")
B
IF({Auto-Status} = “Awaiting Review”, “ :mag: ”,
IF({Auto-Status} = “Complete”, “ :checkered_flag: ”,
IF({Auto-Status} = “Design”, “ :art: ”,
IF({Auto-Status} = “Released to Supplier”, “ :rocket: ”,
IF({Auto-Status} = “On Our Radar”, “ :satellite: ”,
IF({Auto-Status} = “Production”, “ :triangular_ruler: ”,
IF({Auto-Status} = “Cancelled”,“ :skull: ”,
IF({Auto-Status}=“On Hold”, “ :zzz: ”,
IF({Auto-Status}=“Design Queue”,“ :art: :soon: ”,
IF({Auto-Status}=“Content Needed”, “ :question: ”,
IF({Auto-Status}=“Unassigned”, “ :busts_in_silhouette: ”,
IF({Auto-Status}=“Design Route”, “ :art: :arrows_clockwise: ”,
IF({Auto-Status}=“Copy”, “ :pencil2: ️”,
IF({Auto-Status}=“Production Route”, “ :triangular_ruler: :arrows_clockwise: ”,
IF({Auto-Status}=“Production Queue”, “ :triangular_ruler: :soon: ”,
IF({Auto-Status}=“Retouching”, “ :nail_care: ”,
IF({Auto-Status}=“Retouching Queue”, “ :nail_care: :soon: ”,
IF({Auto-Status}=“Released by Production”, “ :airplane: ️”,
“”))))))))))))))))) & " ") &
IF({Rush Request} = 1, “ :fire: ”,"")
Both work fine!
![Chris_Veenstra Chris_Veenstra](https://community.airtable.com/legacyfs/online/avatars/2X/6/689009355e07aa4588c942fea63ae3ac5ba831e4.jpg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 02, 2018 10:48 AM
Thanks Andrew! This just helped me a LOT!
![](/skins/images/DD0CD7D0ACF200EF4456420D87029A3D/responsive_peak/images/icon_anonymous_message.png)