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
Comments
-
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))) -
I think the following works
=IF(AND([Column4]1 = "", [Column5]1 <> ""), 1, 0)
-
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
-
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
-
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?
-
I am not sure but probably more than what you are thinking of before you would notice a difference
-
OK, thx.
-
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
-
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.
-
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))
-
i think its a parenthesis issue again and the end should be TODAY(-7))), 1)
-
Son of a gun. Yes.
-
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..
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives