Finding rows where an <error> occurs in column formula


1 comment

  • Joel Stewart

    Hi Marc, there is not a function that isolates rows based on the state of an error or not. However, if you can understand the different types of errors that you are encountering as the cause, you can setup boolean checks for those items. 

    For example, the record "TX 75201" cannot be converted to an Integer because it contains a letter. I could convert this into a test for non-number characters (other than a period) like this: 


    Using this function or a similar one can let you convert the error causes into a boolean that can easily be filtered for.


    Comment actions Permalink

Please sign in to leave a comment.