Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

IF(ISNUMBER(SEARCH) function

Topic Labels: Formulas
Solved
Jump to Solution
1410 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Rachel_Dor_75
4 - Data Explorer
4 - Data Explorer

I have a column of case numbers. The numbers can be made up of a number only, for example, 832, or a number with a slash and a number after it, for example, 832/1.
I need to create a function that searches for all the numbers that do not have a slash and adds a slash and the digit 0 to them. For example, case number 832 will become 832/0.
In Excel, this can be done with the function IF(ISNUMBER(SEARCH), but this is not supported in Airtable. Do you have a suggestion on how to do this?

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

IF(
  FIND("/", {Case Number}),
  {Case Number},
  {Case Number} & "/0"
)

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

IF(
  FIND("/", {Case Number}),
  {Case Number},
  {Case Number} & "/0"
)

Thank you so much!!