Trying to incorporate ISBLANK into a formula

=IF(ISBLANK([Monday Job]@row, ""), INDEX(COLLECT({Per Diem Database Range 1}, {Per Diem Database Range 2}, [Employee ID]@row, {Per Diem Database Range 3}, [Monday Job]@row), 1),)

Getting an unparseable on this one any help would be greatly appreciated.

Brandon

Find more posts tagged with

Formulas

Accepted answers

All comments

KPH

Hi @Bwoods113

You're nearly there!

At the start of the formula move the "" that you want to appear if Monday Job is blank to outside of the ISBLANK parenthesis. This then puts "" as the result if ISBLANK([Monday Job]@row) is true.

Change

=IF(ISBLANK([Monday Job]@row, ""),

=IF(ISBLANK([Monday Job]@row), "",

Then at the end, remove the comma before the last parenthesis

Change

, 1),)

, 1))

Final formula

=IF(ISBLANK([Monday Job]@row), "", INDEX(COLLECT({Per Diem Database Range 1}, {Per Diem Database Range 2}, [Employee ID]@row, {Per Diem Database Range 3}, [Monday Job]@row), 1))

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.