Skip to main content

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?

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

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


Thank you so much!!

Reply


Terms & Conditions