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

Hello,

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!

Find more posts tagged with

Formulas

Accepted answers

All comments

JamesB

@clairehunter

You are not closing your OR statement before moving to your True/False in your IF command.

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

clairehunter

@JamesB

It is still saying "the column formula syntax is incorrect".

JamesB

@clairehunter

I just copied and pasted the formula and I am not getting an error in my syntax.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.