Can someone help me with this formula? It will not work for the life of me.
=JOIN(COLLECT({Current Loans Range 5}, {Current Loans Range 1},
"CASA"), [{Current Loans Range 2}, "Y"]), "; ")
I finally got it. I am not 100% sure what I changed after staring at this all day
=JOIN(COLLECT({Current Loans Range 5}, {Current Loans Range 1}, "CASA", {Current Loans Range 2}, "Y"), "; ")
Hi @Michelle Lempert
Looks good!
Seems like your first formula had a few extra brackets/parentheses that needed to be removed. I'm glad you figured it out 🙂
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.
