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


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
    SSParks ✭✭✭✭

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

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

  • SSParks
    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
    Toufong Vang ✭✭✭✭✭
    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,

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!