Help with formula to check box based on specific criterion

Hi team - need your help.

I have a formula that computes the actual day between 2 dates (using NETWORKDAY) which returns a number in that column cell (days count).

I have a "helper" check box column next to that column cell that I need checked if the actual days is equal to or less than 10 days AND not 0 (or blank).

I've tried =IFERROR(IF([days counts]@row >0 =< 10, 1, 0),"") but it doesn't work nor does this throw an error (unparsable, etc)

Any ideas on how to go about this formula?

Thanks,

Jeff

Find more posts tagged with

Accepted answers

Paul Newcome

You would need something more like this:

=IF(AND([days counts]@row>0, [days counts]@row<= 10), 1)

All comments

Paul Newcome

You would need something more like this:

=IF(AND([days counts]@row>0, [days counts]@row<= 10), 1)

jmo

@Paul Newcome - once again you come through!

Appreciate the assistance.

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