Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[wig]

I'm hoping one of the board's expression wizards will be able to help me with this question.

I would like to compare the values of two different fields for my library collection, and display all items that don't have identical values.

The specific example: I have a custom field called [Comment Expression]. I would like to test it against the [Comment] field, and display all the items where the values don't match.

Any ideas?

[Matt]

If(IsEqual([Comment Expression], [Comment]), [Comment], nothing)

[wig]

Thanks, Matt!

I ended putting that expression in a custom field, and then creating a smartlist to display all of the files where the values weren't equal. It works exactly like I was hoping for.