If its Blank Formula

Options

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

 

Tags:

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓
    Options

    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)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!