Column Formula Needed: Days remaining until action resolution is needed.

Column in Main Sheet:

Ultimately meaning there are T-X days until resolution action is needed (helper column).

I have thrown the ranges that I am wanting to report in to another sheet, for calculating the count for each range/category.

Formula isn't working and there is where my struggle lies.

Formula:

=COUNTIFS({Coding Questions Request Tracker Sheet w/ Range 1}, AND(@cell >= -1, @cell <= -[Primary Column]-5 ))

Is my issue that I need to use another set of "()" around the negative number that is reporting?
I am need to report ranges to the dashboard in a dounut or pie chart- ultimate goal.

Thank you in advance

Find more posts tagged with

Formulas

Dashboards

Countif

Data links: Column links

Accepted answers

All comments

Paul Newcome

Try removing the piece regarding the PRimary Column.

AND(@cell <= -1, @cell >= -5)

KIMST

Thanks for the feedback. The formula is now parse able, however, incorrect data is displaying.

New Formula:

=COUNTIFS({Coding Questions Request Tracker Sheet w/ Range 1}, AND(@cell >= -1, @cell <= -5 ))

I have confirmed the sheet column for reference is accurate.
It is reporting 0 as the value, but I should have a reportable value of 3.

Helper column testing values listed below.

Any other thoughts of what I may be doing incorrectly here?

Paul Newcome

What is the formula outputting the number of days on the source sheet?

Adam Murphy

I think you have this backwards? (@cell >= -1, @cell <= -5 )) should be (@cell <= -1, @cell >= -5 ))

Sorry if i'm just confused.

Does that work?

Paul Newcome

Switching it around like in my first post should work. I missed that the second time around. If that still doesn't work, the formula that populates the source numbers would be the next thing to look at.

KIMST

simple math error (oh how those little things are sometimes forgotten when not used regularly)- the reversal of the numbers worked! Thank you both for that corrective item!

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.