How do I Automate a Checkmark IF another cell is a certain value
Hi All,
I am trying to automate a checkmark in a checkbox column if the function returns ANY of the dropdown values from another column.
For instance, If the Project Team (Column) assigned is either "DPMO", "Engineering", or "Clinical Effectiveness", I want the cell to have a checkmark ("1). If it has anything else, I would like the cell to be left blank ("0").
Is this possible?
I have tried the following with no luck...
=IF(OR([Project Team]4 = "DPMO", [Project Team]4 = "Engineering", [Project Team]4 = "Clinical Effectivess", "1"))
Best Answers
-
Close..
1) You have a bracket in the wrong spot
=IF(OR([Project Team]4 = "DPMO", [Project Team]4 = "Engineering", [Project Team]4 = "Clinical Effectiveness"), 1)
should work
. Also, don't put the 1 in quotes as it is then text the checkmark type needs a 1 or a 0 (Numeric)
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
-
It worked thank you!
Answers
-
Close..
1) You have a bracket in the wrong spot
=IF(OR([Project Team]4 = "DPMO", [Project Team]4 = "Engineering", [Project Team]4 = "Clinical Effectiveness"), 1)
should work
. Also, don't put the 1 in quotes as it is then text the checkmark type needs a 1 or a 0 (Numeric)
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
-
It worked thank you!
-
Thank you! I was able to model this for a similar issue! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!