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?
Solved
IF(ISNUMBER(SEARCH) function
+2Best answer by kuovonne
IF(
FIND("/", {Case Number}),
{Case Number},
{Case Number} & "/0"
)
+29IF(
FIND("/", {Case Number}),
{Case Number},
{Case Number} & "/0"
)
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.