# 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

Tags:

• ✭✭✭✭

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)

• ✭✭✭✭✭
edited 01/30/24

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..."

Plug-in 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!