# Formula Question: IF Not Blank, Do "This"

Options
✭✭✭✭✭✭

Smartsheeters!

I have a use case where I want to reflect "yes" in a column if a certain range of columns has text in it AND "no" in that column if that range of cells is BLANK. I tried this formula below and it is not working.

What am I missing?

=IF(ISBLANK([SALESFORCE Data Error: Late Fee % or Grace Period]1:[YARDI: Timing Charges Not Billed to Ledger]1), "No", "Yes"))

Thank you!!

• ✭✭✭✭✭✭
Options

I see - that makes sense.

I did try this and it is still showing "#UNPARSEABLE"... hm. Any ideas why this is happening?

• ✭✭✭✭✭✭
edited 05/20/20
Options

my guess is you either misplaced or didn't place the closing parenthesis in the correct location. Can you post the adjusted equation?

EDIT:

never mind, its is the ending parenthesis. You had 2 of them at the very end of your formula, you should only have one. I didn't catch that originally.

• ✭✭✭✭✭✭
Options

=IF(ISBLANK(JOIN([SALESFORCE Data Error: Late Fee % or Grace Period]1:[YARDI: Timing Charges Not Billed to Ledger]1)), "No", "Yes"))

• ✭✭✭✭✭✭
Options

I edited my previous comment, apologies didn't think you would catch it that quick.

• ✭✭✭✭✭✭
Options

it worked! thank you!!!!

• ✭✭✭✭✭✭
Options

Super!

• ✭✭✭✭✭✭
Options

Hello!

I am wanting to add a criteria to this formula :) I want to count if any of the multiple columns is blank AND if it meets the region@row criteria.

Thoughts here?

• ✭✭
Options

Hi

I've got a similar issue... I'd like this column formula to ignore blanks and if not put a '1' for duplicates

=IF(COUNTIFS(Budget:Budget, Budget@row) > 1, 1)

Any help greatly appreciated!

edited 02/16/23
Options

You can ignore blanks by adding a statement at the beginning:

=IF(Budget@row = "", 0, IF(COUNTIFS(Budget:Budget, Budget@row) > 1, 1))

Let me know if that worked for you!

Cheers,

Genevieve

• ✭✭
Options

Thanks @Genevieve P. ! this worked!!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!