I have a board that tracks the cleaning of equipment. The board has a “Done By” column for the initials of the person who cleaned, and a “Verified By” for the person who checked the work. Both columns must be filled in and have different initials. I have a formula column that will evaluate them and tell me if the output is Valid or Invalid:
IF(AND({Done By} <> “”, {Verified By} <> “”, {Done By} <> {Verified By}), “Valid”, “Invalid”)
This formula works every time without issue. The problem is that the output can’t be evaluated by another field (because it’s a formula).
I’d like to use an AI field to accomplish the same thing, but the AI seems to be hit or miss. Sometimes it will return the correct answer and other times it won’t.
Any suggestions from the community? TIA