Check Box if B/O Qty is > 0 OR Status column says "Backorder"


I have been messing with this formula forever and I feel like I am just barely missing the mark, but cannot seem to figure it out nonetheless.

GOAL: If column: "B/O Quantity" = 0 check the box, OR IF column: "Status" says "Backorder" check the box. If both instances occur still check the box.

Okay, the formula I have so far is:

=IF(OR([Status]@row = "Backorder", ([B/O Quantity]@row = > 0, 1 0,)))

I am getting an incorrect syntax error. Thanks for the help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!