Check a Box if Values Greater than 2 appear in any cell in a row

justin.edge · 03/25/24

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.

heyjay · 03/25/24

https://community.smartsheet.com/discussion/comment/427014#Comment_427014

=IF(COUNTIF([3/25/24]@row:10/5/24@row, >2), 1, 0)

heyjay · 03/25/24

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)

justin.edge · 03/25/24

This is very helpful and almost gets me there. Could I put in a range of columns as well? We have 350 columns.

heyjay · 03/25/24

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.

justin.edge · 03/25/24

This is very close, but it comes back as Unparseable. Here's the formula I'm using:

heyjay · 03/25/24

https://community.smartsheet.com/discussion/comment/427014#Comment_427014

=IF(COUNTIF([3/25/24]@row:10/5/24@row, >2), 1, 0)

justin.edge · 03/25/24

That worked! I just had to put brackets around the other column name in the date range! Thank you so much!

Check a Box if Values Greater than 2 appear in any cell in a row

Best Answer

Answers

Categories