Formula Question: IF Not Blank, Do "This"

Nicole Hodges

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!!

L_123

isblank can only look at one item at a time and you have given it a range. You need to convert that range to a single item, then check if it is blank.

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

L_123

isblank can only look at one item at a time and you have given it a range. You need to convert that range to a single item, then check if it is blank.

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

Nicole Hodges

I see - that makes sense.

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

L_123

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.

Nicole Hodges

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

L_123

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

Nicole Hodges

it worked! thank you!!!!

L_123

Super!

Nicole Hodges

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?

RebeccaF

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!

Genevieve P.

Hi @RebeccaF

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

RebeccaF

Thanks @Genevieve P. ! this worked!!!