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

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

Any assistance appreciated..