How to use IF(ISBLANK and another IF formula?

Tina

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

Find more posts tagged with

Accepted answers

Andrew Stewart

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

All comments

Andrew Stewart

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

Tina

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.

Andrew Stewart

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.