If its Blank Formula

Brittanyy

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].

 

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)

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

👍