Formula to determine is something is due this week

I am trying to get my parent row 'On Site Helper" box to check if any children have activity in the current week. Right now I have a formula to check my "on site helper" box

=IF(AND(Start@row <= TODAY(), Finish@row >= TODAY(), COUNT(PARENT([Scope of Work]@row)) > 0), 1, IF(COUNTIF(CHILDREN(), 1) >= 1, 1))

If i sue this same formula in the parent row then is is always checked even when I have a gap in site activity.

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.