Using IF Statement & DATE

I'm trying to combine formulas that if a check box is clicked, it returns the number 7 to me or else it runs a formula for subtracting dates from TODAY but unfortunately I keep getting #INVALID DATA TYPE

=IF(OR(COMPLETE@row, "7"), (TODAY() - DATE@row))

Any help would be great appreciated. Thanks.

Find more posts tagged with

Formulas

functionality

Accepted answers

Frank Falco

Assuming COMPLETE is a check box then try

=IF(COMPLETE@row=1,7,TODAY() - DATE@row)

Evaluating a checkbox is 1 if selected, 0 if not. So thus the COMPLETE@row=1 .

If the is true, then return 7, else return the number of days between the date and today.

All comments

Frank Falco

Assuming COMPLETE is a check box then try

=IF(COMPLETE@row=1,7,TODAY() - DATE@row)

Evaluating a checkbox is 1 if selected, 0 if not. So thus the COMPLETE@row=1 .

If the is true, then return 7, else return the number of days between the date and today.

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.