Checkbox formula based on 2 columns matching
Hello,
I'm sure i'm creating extra steps for myself on this but here is my issue at this time.
My goal is to set up notifications on one smartsheet when there is a manager change on the master smartsheet.
I broke it down into steps.
First, I created a formula on the smartsheet I want the notification to populate. I have my manager listed, and referenced the correct manager from the master sheet in the column next to that.
Now i'm trying to check the box next to those if the managers don't match.
After, I will set up notifications based on the check box.
How do I create a formula checking the box if the two columns don't match?
Thank you,
Kristin
Best Answer
-
Put this in your check bock cell
=if("column1"="Column2",0,1)
Answers
-
Put this in your check bock cell
=if("column1"="Column2",0,1)
-
Thank you! That worked! I apprecaite the help
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!