Formula to Select Multiple Dropdown Options using Two-Column Criteria

Hello,

I am looking to be able to auto-populate the pending permits based on the empty date cells where we input our received dates.

I currently have to manually choose what permits are missing, but am hoping there is a formula I can use to show both missing permits. Below is what it currently looks like and after that is what I'd like it to look like using a formula to generate the two permits missing on the row in the same cell.

I may need to add in a third if missing a Special Permit.

Find more posts tagged with

Formulas

Accepted answers

Mark.poole

@dhills922

=IF([Town Pole]@row <>"","Town Pole Permit")+" "+IF([State Pole]@row <>"","State Pole Permit")+" "+IF(And([Special Permits]@row<>"",[Special Permits]@row<>"N/A"),"Special Permit")

There is no functionality to use a multi select option in a formula. How ever you can do text.

All comments

Mark.poole

@dhills922

=IF([Town Pole]@row <>"","Town Pole Permit")+" "+IF([State Pole]@row <>"","State Pole Permit")+" "+IF(And([Special Permits]@row<>"",[Special Permits]@row<>"N/A"),"Special Permit")

There is no functionality to use a multi select option in a formula. How ever you can do text.

dhills922

That worked! I tweaked it a bit and got rid of the "AND" where I don't want to count the N/A and the additional Special Permits section. I never would have gotten that one. Thank you!

Mark.poole

your very welcome. I did the special permits part just in case you wanted to add that into it maybe at a later point.

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.