NESTED IF formula

Hello again, I tried to ask this in my last thread of another question with similar columns but realized I should just create a new question.

I have a column titled LICENSE TYPE that I would like to populate if there is text in one of the above 4 columns with the text in that column. Each row will only have 1 of the 4 columns populated. Can you assist with this formula as well? In rows 1-3 the LICENSE TYPE column should contain Pharmacy-nonresident and rows 4-5 would have Sterile Compounding while 6-10 would have Manufacturer, etc.

Thank you!

Find more posts tagged with

Accepted answers

Melanie Sanders

Thank you! Worked like a charm.

All comments

Louis1

Hi M,

I did this that may provide what you want - the formula column (also set as acolumn formula) is

=IF([Licence Type A]@row <> "", [Licence Type A]@row , IF([Licence Type B]@row <> "", [Licence Type B]@row , IF([Licence Type C]@row <> "", [Licence Type C]@row , [Licence Type D]@row )))

Just replace A, B, C and D in the formula with your headings

Melanie Sanders

Thank you! Worked like a charm.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.