Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

AND + NOT isblank

Joshua Rose

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

Comments

Joshua Rose

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

ricki

I think the following works

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

J. Craig Williams

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

ricki

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

Joshua Rose

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?

ricki

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

Joshua Rose

OK, thx.

J. Craig Williams

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

Joshua Rose

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.

Joshua Rose

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

ricki

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

Joshua Rose

Son of a gun. Yes.

Morri Young

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