Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Writing a formula on different lines?

Topic Labels: Formulas
219 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a way to put parts of a formula (while writing or editing it) on separate lines, like in a visual editor, to better organize? It works when I cut and paste, but I can’t figure out how to do it in the box.
Any suggestions?

1 Reply 1

In other words, how would I put this in to the editor, without cutting and pasting?:

SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
  {Article content},
     "Apple","Apple (NASDAQ:AAPL)"),
     "Alphabet","Alphabet (NASDAQ:GOOG)"),
     "Microsoft","Microsoft (NASDAQ:MSFT)"),
     "Amazon","Amazon (NASDAQ:AMZN)"),
     "Facebook","Facebook (NASDAQ:FB)")