Need formula to check a box if another column is under < $1,000 remaining.
Greetings
I need a formula to select the Alert checkbox if the Remaining $ is under $1,000 left. One time
Id also be curious if possible to do this based on a percentage left of the original PO Amount. ex If I have 10% of the original starting PO amount left.
Thanks for any info! MD
Answers

This worked for me to check the box for accounts with less then $1,000
=IF(Remaining@row < 1000, 1, 0)

Same forumla checking if the remaining is less then ten percent of the total from PO Amount left:
=IF(Remaining@row < 0.1 * [PO Amount]@row, 1, 0)

Hi, @SSParks , since you want the box to be checked when either of those two conditions is met, you will need to use the OR() function.
For example: IF( OR(condition1, condition2), 1, 0) ...that is to say, "IF condition1 is true OR condition2 is true, then..."
Plugin your 2 conditions and the result is...
condition1 = Remaining@row < 1000
condition2 = Remaining@row < 0.1 * [PO Amount]@row
=IF(OR(Remaining@row < 1000, Remaining@row < 0.1 * [PO Amount]@row), 1, 0)
Here's additional documentation on Smartsheet functions, https://help.smartsheet.com/functions
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!