Quote:
Originally Posted by eschwartz
Well, assuming they are both yesno type columns:
Code:
program:
test(
and(
field('#new',
not(
field('#readingstatus')
)
),
'1-New',
''
)
|
This works (other than one missing closed parenthesis, but that was easy to fix)! 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.