Need formula to check a box if another column is under < $1,000 remaining.

SSParks

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

SSParks

This worked for me to check the box for accounts with less then $1,000

=IF(Remaining@row < 1000, 1, 0)

SSParks

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)

Toufong Vang

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