[eschwartz]

Originally Posted by matanic

This works (other than one missing closed parenthesis, but that was easy to fix)!

Huh, how about that. (Fixed for posterity.)

My #readingstatus column is not Yes/No but I created another custom column from the #readingstatus column that was Yes/No and it works great! Thanks for the quick reply!

Just out of curiosity, how would you use the and/not or something similar with a function that is testing against a pattern instead of just looking for empy/not empty? I had actually tried using GPM instead of TPM, but I couldn't get any type of and/not or and/or to work with the contains function.

As chaley said.

Contains can be used to return "1" or the null value "" depending on the match, and the and() and not() functions are booleans that check for non-empty strings.

So, we can cut down on the number of custom columns by using:

program:

test(
    and(
        field('#new'),
            contains(field('#readingstatus'), '100%_I_am_done_yay', '', '1-New')
    ),
    '1-New',
    ''
)

Or whatever is in your #readingstatus column.