Formula Returns Blank Result

Hi all,

Please can someone help. I have a formula that has worked every day up until today (Thursday). Can anyone spot what I am doing wrong?

=IF(WEEKDAY(TODAY()) = 2, COUNTIF({Date Received}, TODAY(-3)), IF(WEEKDAY(TODAY()) = 1, COUNTIF({Date Received}, TODAY(-2)), IF(WEEKDAY(TODAY()) = 7, COUNTIF({Date Received}, TODAY(-1), IF(WEEKDAY(TODAY()) = 4, COUNTIF({Date Received}, TODAY(-1), IF(WEEKDAY(TODAY()) = 3, COUNTIF({Date Received}, TODAY(-1)), IF(WEEKDAY(TODAY()) = 5, COUNTIF({Date Received}, TODAY(-1)), IF(WEEKDAY(TODAY()) = 6, COUNTIF({Date Received}, TODAY(-1)))))))))))

Thanks,

Meg

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

It looks like a misplaced closing parenthesis after the first and second TODAY(-1). Once you add those in, double check your ending parenthesis. You should have 7.

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.