If its Blank Formula

Hi There,

I need assistance on ItsBlank formula.

Formula I currently have that isn't working

=IF(ISBLANK([Other Concerns]@row), [Name of Company]@row + "presently had no other comments or concerns.").",If [Name of Company]@row="1" +[Name of Company]@row+ "also responded that"+[Other Concerns]@row))

My Output information:

If "Other Concerns" has no response, then show: [Name of Company] presently had no other comments or concerns.

If "Other Concerns" has a response, then show :[Name of Company] also responded that [Other Concerns].

Find more posts tagged with

Formulas

Accepted answers

Carson Penticuff

Give this a try:

=IF(ISBLANK([Other Concerns]@row), [Name of Company]@row + " presently had no other comments or concerns.", [Name of Company]@row + " also responded that " + [Other Concerns]@row)

All comments

Carson Penticuff

Give this a try:

=IF(ISBLANK([Other Concerns]@row), [Name of Company]@row + " presently had no other comments or concerns.", [Name of Company]@row + " also responded that " + [Other Concerns]@row)

Brittanyy

@Carson Penticuff This worked!

Thank you so much.

Carson Penticuff

👍

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.