Formula error on Duplicate date check

Have found this formula in previous discussions but is unparseable.

I have gone through it a couple of times and think it is down to wrongly set parentheses, or?

Slutdato=enddate, Startdato=start date. Looking to flag (double booking) if startdates or enddates overlap.

=IF(ISBLANK(Startdato@row; “”); IF(ISBLANK(Slutdato@row; “”; IF(COUNTIFS(Slutdato:Slutdato; <=Slutdato@row; Slutdato:Slutdato; >=Startdato@row) + COUNTIFS(Startdato:Startdato; >=Startdato@row; Startdato:Startdato; <=Slutdato@row) + COUNTIFS(Startdato:Startdato; <=Startdato@row; Slutdato:Slutdato; >=Startdato@row) - 3) > 0; 1; 0))

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

Yes. There are some parenthesis issues with your formula. Below is a more simplified version.

=IF(OR(ISBLANK(Startdato@row); ISBLANK(Slutdato@row)); ""; IF(COUNTIFS(Slutdato:Slutdato; >= Startdato@row; Startdato:Startdato; <= Slutdato@row) >1; 1))

All comments

Paul Newcome

Yes. There are some parenthesis issues with your formula. Below is a more simplified version.

=IF(OR(ISBLANK(Startdato@row); ISBLANK(Slutdato@row)); ""; IF(COUNTIFS(Slutdato:Slutdato; >= Startdato@row; Startdato:Startdato; <= Slutdato@row) >1; 1))

HOFF

Works beautifully, thank you.

I will spend some time learning the proper syntax for future use.

🙏

Paul Newcome

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.