Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Compare text in two different columns
I have a large SS that includes two rows of columns...one is the listing of the latest print revision, and I want to compare it to another column reporting which revision the part was actually built to. Both of these columns are populated with a letter (NC, A, B....AZ).
My goal is a Conditional format color if the two columns do NOT agree.
I am fine with building a hidden column where a formula resides, populating a 0 or 1 (then having the Conditional Format built from there).
My problem: Is there a formula that will give me that answer, and if so, what is it??