Im trying to check the box in Column 2 with either TTP or TTV value in either Column’s 3 or 4 and th
Best Answer
-
Hello @Hobo
It looks like your request was truncated. Are you trying to check the box if either columns have TTP or TTV in them? Is there more to the condition? If not, try the formula below.
=IF(COUNTIFS([Column 3]@row:[Column 4]@row, OR(@cell = "TTP", @cell = "TTV")) > 0, 1)
Will this work for you?
Kelly
Answers
-
Hello @Hobo
It looks like your request was truncated. Are you trying to check the box if either columns have TTP or TTV in them? Is there more to the condition? If not, try the formula below.
=IF(COUNTIFS([Column 3]@row:[Column 4]@row, OR(@cell = "TTP", @cell = "TTV")) > 0, 1)
Will this work for you?
Kelly
-
Hi Kelly thanks this works perfectly!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!