Here is the formula I am trying and it's brining back #CIRCULAR REFERENCE
=IF(AND([FPI Date]@row >= DATE({StartYr}, {StartMth}, {StartDy}), [Jan FPI]@row <= DATE({EndYr}, {EndMth}, {EndDay})), [eCOA_ID]@row , "")
I'm so terrible at dates, mainly because i dont use them in my formulas; but this may help you if you have access to it?AI Formulas Text Generator
What column are you putting this formula into? DO any of the columns or ranges referenced have formulas in them? If so, what are they?
You need to INDEX/MATCH to get the correct StartYr, StartDy, StartMth, as well as for the EndDy, EndMth, EndYr, because right now your formula is pulling full columns of values and it does not know what to do with it.
Does this make sense? So your Formula would become very very long but would be something like:
=IF(AND([FPI Date]@row >= DATE(INDEX({StartYr}, MATCH({ID #}, ID@row, 0), INDEX({StartMth}, MATCH({ID #}, ID@row , 0), INDEX({StartDy}, MATCH({ID #}, ID@row , 0)), [Jan FPI]@row <= DATE(INDEX({EndYr}, MATCH({ID #}, ID@row , 0), INDEX({EndMth}, MATCH({ID #}, ID@row , 0), INDEX({EndDay}, MATCH({ID #}, ID@row , 0))), [eCOA_ID]@row , "")
That make sense?
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.
