Check a Box if Values Greater than 2 appear in any cell in a row
I've seen many posts about box check =IF formulas, but they all reference specific columns in brackets. Is there a formula I could use @row that would search the entire row for numbers greater than 2 and check a box if there is a number greater than 2?
Thank you! This helps flag when the workforce has been overscheduled.
Best Answer
Answers
-
You can do a combination of IF Statement and OR function.
Status = =IF(OR( A@row > 2, B@row > 2, C@row > 2, D@row > 2), 1, 0)
...
-
This is very helpful and almost gets me there. Could I put in a range of columns as well? We have 350 columns.
-
For column range, you can use
[Column Name:Column Name]
. Or if you mean to apply the function to the entire row, you can convert the it to a column formula....
-
This is very close, but it comes back as Unparseable. Here's the formula I'm using:
-
-
That worked! I just had to put brackets around the other column name in the date range! Thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives