Using OR in a formula

Hi there -

My goal is to have a formula that notes if Bayside Conversion is Completed or Completed - Not Implemented, then enter 5 into cell, otherwise enter 0.

Here is my current formula, I am getting "UNPARSEABLE"

=IF([BAYSIDE CONVERSION]@row = "COMPLETED", OR(@row = "COMPLETED - NOT IMPLEMENTED", 5, 0))

Thanks!

Find more posts tagged with

Accepted answers

All comments

Nick Korna

Hi @aecross,

The formula you would need is:

=IF(OR([Bayside Conversion]@row = "Completed", [Bayside Conversion]@row = "Completed - Not Implemented"), 5, 0)

Hope this helps; if you've any questions etc. then just post! 😊

Ipshita

Hello @aecross Here is your answer -

Instead of Status, enter your Bayside Conversion :)

=IF(OR(Status@row = "Completed", Status@row = "Completed - Not Implemented"), 5, 0)

Hope this helps!

Cheers!

Ipshita

aecross

That worked! Thank you, Nick!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.