Expanding IF(ISBLANK formula
Hi,
I'm trying to expand this formula =IF(ISBLANK(Email@row), "Red", "Green") to return the same status result of "Red" if blank or "Green" if filled in, when any of the shown cells are blank, not just the email. I have tried many formulas with IF OR AND but I'm certain I'm just not putting it together correctly. Any help would be appreciated.
=IF(ISBLANK(Email@row), "Red", "Green")
Best Answer
-
Try something like this...
=IF(OR(Company@row = "", [First Name]@row = "", [Last Name]@row = "", Title@row = "", Email@row = ""), "Red", "Green")
Answers
-
Try something like this...
=IF(OR(Company@row = "", [First Name]@row = "", [Last Name]@row = "", Title@row = "", Email@row = ""), "Red", "Green")
-
Thanks Paul! Works like a charm!
-
Happy to help! 👍️
-
i have same quesiton but have several columns, can it work without listing each column and having a range? Compnay@row:Email@row ="" ?
-
@Ahmed Elmonoufy Try something like this...
=IF(COUNTIFS(Company@row:Email@row, "") > 0, "Red", "Green")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!