Auto Check a box when one column is greater than another
Is there a formula or function that I can set up when the amount in one column is greater than the amount in another column, a box is checked? This will essentially be a spreadsheet to keep track of percentages on a week by week basis. So when the percentage on the 10/24 column is greater than the percentage on the 10/17 column, I'd like a box in another column to automatically check.
The only thing i can find is conditional formatting for when the percentage is higher than a determined value.
TIA
Best Answer
-
Hi @JPavlasek ,
You can use this formula in the checkbox row.
=IF([10/24]@row > [10/17]@row, 1)
Keep in mind, this only works for 10/24 and 10/17, if you are trying to compare other columns, you would need to change the formula.
Hope this helps,
Dave
Answers
-
Hi @JPavlasek ,
You can use this formula in the checkbox row.
=IF([10/24]@row > [10/17]@row, 1)
Keep in mind, this only works for 10/24 and 10/17, if you are trying to compare other columns, you would need to change the formula.
Hope this helps,
Dave
-
That's AMAZING, THANK YOU!!!!! It worked!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!