#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# AND + NOT isblank

Options
edited 12/09/19

Trying to produce a formula which says if X is blank and Y is not blank, then check.

=IF(AND([Eval Cost]1 = "", (NOT([Client]1=""), 1,0)

Thanks

Tags:

## Comments

• Options

Here are a few more attempts (using different cells). I must be close...?

=IF(AND(NOT(ISBLANK([No Show Log]1, [No Show Running Cost]1 IS BLANK), 1, 0)

=IF(NOT(ISBLANK([No Show Log]1, AND([No Show Running Cost]1 = ""), 1, 0)))
• ✭✭✭✭✭✭
Options

I think the following works

=IF(AND([Column4]1 = "", [Column5]1 <> ""), 1, 0)

• ✭✭✭✭✭✭
Options

ricki,

That works.

This will too:

=IF(AND(ISBLANK([Column4]1), NOT(ISBLANK([Column5]1))), 1, 0)

I'm curious which one processes faster. I would assume yours.

Craig

• ✭✭✭✭✭✭
Options

This particular formula is simple enough that it probably doesnt matter performance wise either way ..... in general i dont like using not's for multiple reasons (they can be a performance hit, they reduce the readability of the formulas/queries, etc) so i try not to use them unless i have to

• Options

Bingo! While I've got you both here--any rough guidelines for how many formulas (assuming not overly complex formulas) begin to be "too many" in terms of real performance hits?

• ✭✭✭✭✭✭
Options

I am not sure but probably more than what you are thinking of before you would notice a difference

• edited 02/20/17
Options

OK, thx.

• ✭✭✭✭✭✭
Options

I currently do not have a "how many is too many" thumbrule yet. Neither does Smartsheet support, at least one that they have been willing to share.

The first is a sore subject with me.

Craig

• Options

I guess if I never know that's a good sign. But it would be good to know ahead of time, since that information would help me to plan out/prioritize overall formula-building for the sheet.

• edited 02/20/17
Options

Hope I'm not take advantage here... running into another glitch I haven't been able to sort out:

=IF(AND([Eval Interview Status]1 = "VTA3", ([Last Client Contact Logged]1 < TODAY(-7)), 1))

• ✭✭✭✭✭✭
Options

i think its a parenthesis issue again and the end should be TODAY(-7))), 1)

• Options

Son of a gun. Yes.

• Options

Hi there

I have a question which I think is a variation on this theme

Three Columns, being

• Col1 (Month in Year Due)
• Col 2(Current Month
• Col 3 (Action Required)

So the results I need are

• if either Col1 is empty, then Col3 is empty.
• if Col 1=Col 2, then Col 3="Yes"
• if Col1 does not equal Col 2, then Col 3="No"

I understand how to pull the month from the date with MONTH, but its the logic statements I cant get...

Any assistance appreciated..

This discussion has been closed.