Looking for a formula that considers two columns
A would like a Check Box Cell to be flagged if the following conditions are met:
 Column "EDI Error Type" = X
AND
 Column "Error Details" has a duplicate value.
*The columns considered are both TEXT and column to be updated is a Checkbox type.
I am currently using this formula to flag a box that considers a single column and it works perfectly, I would just like to enter another variable..
=IF(ISBLANK([Integration Key]@row), 0, IF(COUNTIF([Integration Key]:[Integration Key], [Integration Key]@row) > 1, 1, 0))
Answers

=IF(X@row = Y@row, 1, 0)
Make sure to set the formula column to a checkbox property.
...

I will clarify the ask in the original post, thank you!

Try this:
=IF(AND([EDI Error Type]@row = "X", [Error Details]@row = "X"), 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!