Help

New to Formulas...Can I insert a character?

Topic Labels: Formulas
Solved
Jump to Solution
332 1
cancel
Showing results for 
Search instead for 
Did you mean: 
chrisberry
5 - Automation Enthusiast
5 - Automation Enthusiast

I have this formula as 1 of 3 parts that's extracting certain bits of data from a reference cell into 3 adjacent cells. What I'm wondering is if I can add something to get a specific character insert BEFORE the info...

Example
reference cell contains : flavor1, flavor2, flavor3 
This part below pulls out "flavor1" into a 2nd cell
I'd like it to do that but add a " / " before the flavor
So the result would be " / flavor1"

IF( FIND(",", FlavorsLookup1_1),
LEFT({FlavorsLookup1_1},
FIND(",", {FlavorsLookup1_1})-1
),
{FlavorsLookup1_1}
)
 
 
Thoughts/suggestions are appreciated in advance.
1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Adding text is easy.

IF( FIND(",", FlavorsLookup1_1),
  "/ " & LEFT({FlavorsLookup1_1},
    FIND(",", {FlavorsLookup1_1})-1
  ),
  "/ " & {FlavorsLookup1_1}
)

I would like to introduce here a new function in Airtable, the ALLAYSLICE function.
It is available for Lookup and Rollup fields from the Formula field (or Rollup field).
When used in your formula, for example, it will look like this

"/ " & ARRAYSLICE({FlavorsLookup1_1}, 1, 1)

This function cannot be used directly to the "Link to other table" field, so you need to add a lookup field with the Flaver name.

See Solution in Thread

1 Reply 1
Sho
11 - Venus
11 - Venus

Adding text is easy.

IF( FIND(",", FlavorsLookup1_1),
  "/ " & LEFT({FlavorsLookup1_1},
    FIND(",", {FlavorsLookup1_1})-1
  ),
  "/ " & {FlavorsLookup1_1}
)

I would like to introduce here a new function in Airtable, the ALLAYSLICE function.
It is available for Lookup and Rollup fields from the Formula field (or Rollup field).
When used in your formula, for example, it will look like this

"/ " & ARRAYSLICE({FlavorsLookup1_1}, 1, 1)

This function cannot be used directly to the "Link to other table" field, so you need to add a lookup field with the Flaver name.