IF(OR( formulas

Hi there,

I reached an impasse with IF(OR( formula. I've 3 columns named as below :

STATUS INMETEN / STATUS MODEL / Step 1 - Gescande Club

In each column, I've several data filled in. I wrote the following fucntion :

IF(OR([STATUS INMETEN]@row = "Inmeten afgerond", [STATUS INMETEN]@row = "2 - Pointcloud", [STATUS INMETEN]@row = "3 - Pointcloud", [STATUS INMETEN]@row = "Losse Pointcloud", [STATUS INMETEN]@row = "Pointcloud Extern", [STATUS INMETEN]@row = "Pointcloud", [STATUS MODEL]@row = "Niet uibesteed", [STATUS MODEL]@row = <>""), "#1 - Gescande Club")

(All "..." is data filled in cells of column "STATUS INMETEN" or "STATUS MODEL"

But this formula doesn't work for a reason I don't understand. Can someone help me out?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Are you getting an error or an unexpected result?

Paul_Arnaud

Hi Paul,

Thanks for taking time to react on my post. I indeed find out the mistake. I simply changed the part = <>"")( at the end of the formulas) by = "").

What it looks like now :

And it's working just fine ! Thanks for your time.

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.