Formula help! If cell is not blank, return value from another cell

liammac1988

I'm having trouble building a formula that works for the below requirement (see screenshot for reference).

If the cell in column 'INT / DOM / TEMP / NG' is NOT BLANK, then I need the column 'TITLE (Formula)' to pull through the value from a specific cell ('A1' in Excel terms, or 'TITLE / Security Title' in the example shown in the screenshot - the one in blue and yellow).

This is needed because I want to create several duplicates of this sheet, each one for a different 'TITLE / Security Title', and then create a Report that pulls all of the sheets together, with the rows able to be grouped by 'TITLE (Formula)' but ONLY if those rows contain anything in the 'INT / DOM / TEMP / NG' column.

I hope this makes some sense - can anyone help me with the formula?

Find more posts tagged with

Accepted answers

KPH

I believe this formula, entered in the TITLE (Formula) column would work for you:

=IF(ISBLANK([INT / DOM / TEMP / NG]@row), "", TITLE$1)

It creates this:

You start with an IF

For the logical expression you use ISBLANK

ISBLANK([INT / DOM / TEMP / NG]@row) is checking that the cell in the column INT / DOM / TEMP / NG is blank

If that is true it puts in "" (ie nothing)

If it is false it puts in the value in the TITLE column, but instead of TITLE@row, it pulls just from row 1 because of the $1

All comments

KPH

I believe this formula, entered in the TITLE (Formula) column would work for you:

=IF(ISBLANK([INT / DOM / TEMP / NG]@row), "", TITLE$1)

It creates this:

You start with an IF

For the logical expression you use ISBLANK

ISBLANK([INT / DOM / TEMP / NG]@row) is checking that the cell in the column INT / DOM / TEMP / NG is blank

If that is true it puts in "" (ie nothing)

If it is false it puts in the value in the TITLE column, but instead of TITLE@row, it pulls just from row 1 because of the $1

liammac1988

AMAZING thank you! 😀

KPH

My pleasure!

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.