I was able to spend a bunch of time this weekend and managed to follow all your instructions and get everything working properly, so thank you so much. It did need an 'OR', not an 'AND'... I should have thought of that since I run into that issue in Excel sometimes
If I could get one more piece of advice though, I'd really appreciate it... I thought it would be very easy to add one more useful piece of criteria to the code, but it keeps telling me it needs a closing parenthesis, but doesn't say where. As far as I can tell, they are all closed.
Code:
program:
test(
or(
strcmp(field('#keep_read'), 'yes', '', 1, ''),
strcmp(field('#keep_read'), 'series incomplete' '', 1, ''),
strcmp(field('#read_status'), 'N', '', 1, '')
),
'Yes',
'No');
Thanks
