If/Or
Hello,
I am trying to create a flag function based on two Date columns. I want the Flag to go up if either the Date 1 or Date 2 column.
I have unsuccessfully tried: IF(OR([Date 1]@row), "Blank", ([Date 2]@row), "Blank", "Flag", "Unflag")
should I be using numbers instead of "Blank"?
Thank you
Best Answer
-
Hey @Sarah Salazar
My personal preference is to designate a blank cell using the double double-quote characters because it’s less typing and I don’t have to keep up with parentheses. Otherwise, you must use the ISBLANK() function. I’ll write your formula both ways.
Flags are turned ON and OFF like checkboxes using zereos and ones. Numbers are not enclosed with quotes.
=IF(OR([Date 1]@row=“”, [Date 2]@row=“”, 1)
Or
=IF(OR(ISBLANK([Date 1]@row), ISBLANK([Date 2]@row)), 1)
Does that work for you?
Kelly
Answers
-
Hey @Sarah Salazar
My personal preference is to designate a blank cell using the double double-quote characters because it’s less typing and I don’t have to keep up with parentheses. Otherwise, you must use the ISBLANK() function. I’ll write your formula both ways.
Flags are turned ON and OFF like checkboxes using zereos and ones. Numbers are not enclosed with quotes.
=IF(OR([Date 1]@row=“”, [Date 2]@row=“”, 1)
Or
=IF(OR(ISBLANK([Date 1]@row), ISBLANK([Date 2]@row)), 1)
Does that work for you?
Kelly
-
Thank you @Kelly Moore the second one worked perfectly. I appreciate your explanation. Thank you so much!
-
Oops, I forgot the closing OR parenthesis in my first one- that's the challenge of typing on the cellphone.
=IF(OR([Date 1]@row=“”, [Date 2]@row=“”), 1)
Glad one of them worked first try
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!