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
Check out the Formula Handbook template!