Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 26, 2023 08:54 PM
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! Go to Solution.
Feb 26, 2023 09:10 PM
Feb 26, 2023 09:10 PM
IF(
FIND("/", {Case Number}),
{Case Number},
{Case Number} & "/0"
)
Feb 26, 2023 10:46 PM
Thank you so much!!