Pulling info from Reference Sheet based on Date

Hello,

I am trying to pull the information I need based on a date on the referenced sheet. Without this criteria the formula works great. this one criteria is not working. I created a helper column on each sheet. on the reference sheet is a formula to calculate the month number for that row, and then on main sheet is a column for manual entry of the month number. in the screenshot you can see the fomula working for the rotation dates without the month criterion, and blank (in red) after the additional criteria was added. Blue is the manual entry column to trigger the formula.

=JOIN(COLLECT({Prime Student Onboarding Worksheet Rate Total}, {Prime Student Onboarding Worksheet School}, School@row, {Prime Student Onboarding Worksheet Rate Total}, NOT(CONTAINS("-", @cell)), {Prime Student Onboarding Start Month}, CONTAINS([Invoice Month]@row, @cell), {Prime Student Onboarding Worksheet Cancelled}, false), CHAR(10))

Find more posts tagged with

Accepted answers

MedaUser

Hi @Deonizia Egan,

Looking at your formula, specifically what you bolded, do you need the CONTAINS command? I'm thinking you could just make the criterion [Invoice Month]@row.

All comments

MedaUser

Hi @Deonizia Egan,

Looking at your formula, specifically what you bolded, do you need the CONTAINS command? I'm thinking you could just make the criterion [Invoice Month]@row.

Deonizia Egan

thank you so much! once again, such an easy fix and I just can't see it from the weeds. I love this community!

MedaUser

No problem! Happy to help!

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.