Multiple conditions with IF and PARENT ()

Jean Kim

Trying to get multiple conditions working with IF + PARENT ()

If formula works when it's used alone.

=IF(Type@row = "task", "") -> Works

=IF(Type@row = "subtask", PARENT(ID@row)) -> Works

However, when I tried to combine the formula, it returns UNPARSEARBLE.

=IF(Type@row = "task", ""), if(type@row="subtask", PARENT(ID@row)) -> Doesn't work.

What is wrong with above formula?

Find more posts tagged with

Accepted answers

Ramzi K

In your formula:

=IF(Type@row = "task", ""), if(type@row="subtask", PARENT(ID@row))

You are missing you closed the firs if too soon (with the ")" coming too early. You also need the "if false" clause at the end.

Try this:

=IF(Type@row = "task", "", if(Type@row="subtask", PARENT(ID@row),"")

Cheers,

Ramzi

All comments

Ramzi K

In your formula:

=IF(Type@row = "task", ""), if(type@row="subtask", PARENT(ID@row))

You are missing you closed the firs if too soon (with the ")" coming too early. You also need the "if false" clause at the end.

Try this:

=IF(Type@row = "task", "", if(Type@row="subtask", PARENT(ID@row),"")

Cheers,

Ramzi

Jean Kim

Great! Thanks heaps!

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.