How to use IF(ISBLANK and another IF formula?
Hello,
I am trying to create a formula and I need some help.
The formula would be in a column which have a single select dropdown option: Update.
The formula would use information from two columns. The column names are Level and Latest Update.
If the Level = 2, and the Latest Update is not blank, I would like the formula to return Update.
The following formula works however, I can't figure out how to combine it with the Level =2 condition.
=IF(ISBLANK([Latest Update]@row), "", "Update")
Any help is appreciated.
Thank you,
Tina
Best Answer
-
Hi Tina,
You can just put an AND and NOT condition into your IF statement, eg:
=IF(AND(NOT(ISBLANK([Latest Update]@row)),Level@row=2), "Update","")
Regards,
Andrew
Answers
-
Hi Tina,
You can just put an AND and NOT condition into your IF statement, eg:
=IF(AND(NOT(ISBLANK([Latest Update]@row)),Level@row=2), "Update","")
Regards,
Andrew
-
Thanks Andrew! Is there a way that I can also add this in to the formula? =IF(Level@row = 1, "Project Update")
I keep getting an error.
-
The syntax is IF(condition, value if true, value if false). I find the best way is to start from something simple that works and keep adding more complexity.
In this case, I understand you want to set the field only if the latest update is not blank. So start from:
=IF(NOT(ISBLANK([Latest Update]@row)),"Something","")
Now you want the "Something" above to vary based on the Project level. If there are more than 2 project levels, you need to cater for the others. So :
"Something" = IF(Level@row = 1, "Project Update",IF(Level@row = 2, "Update",""))
Putting the second into the first, you end up with:
=IF(NOT(ISBLANK([Latest Update]@row)), IF(Level@row = 1, "Project Update",IF(Level@row = 2, "Update","")),"")
Which will be blank if the latest update is blank or the project level is not 1 or 2, "Project Update" if the level is one, "Update" if the level is two.
Is that what you are after?
Help Article Resources
Categories
Check out the Formula Handbook template!