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??
Comments
-
If you do indeed create a third hidden column, the formula for that column would look like this...ย =IF([First Cell}= [Second Cell], 1, 0) ย ย Meaning that if the two are equal, it will produce a one, if not then a zero. Then you can set a new rule in conditional formating (the colorful grid in your toolbar) to turn the values in that column a certain color if they do or do not match. ย Hope this helps!
-
Well I could have sworn I tried that previously, but it did work this time. ย Thanks so much for your assistance!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives