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
 Smartsheet Customer Resources
 63K Get Help
 379 Global Discussions
 213 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!