nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Help me fix my formula

benetta.francique

Please help!

=COUNTIFS([Points Received]:[Points Received], "Incident", [Employee ID #]:[Employee ID #], $[Employee ID #]@row, Date:Date, <=[Today's Date]5528, Date:Date, >=[Incident 24 Months]5528) + COUNTIFS([Points Received]:[Points Received], "Accident", [Employee ID #]:[Employee ID #], $[Employee ID #]@row, Date:Date, <=[Today's Date]5528, Date:Date, >=[Accident 24 Months]5528)

Find more posts tagged with

Formulas

Accepted answers

All comments

Philip Robbins

@benetta.francique What's the nature of the error you are getting? Is it #UNPARSEABLE or something else?

Paul Newcome

What is happening vs what are you expecting?

Andrée Starå

https://community.smartsheet.com/discussion/148154/help-me-fix-my-formula

Hi,

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Have a fantastic day!

Andrée Starå | Smartsheet Expert Consultant and Partner / CEO @ WORK BOLD

✅ Did my comment/answer help? Please support with 💡 ⬆️ ❤️ ✅ so others find it. Thank you! 🙏

benetta.francique

This is how I have it set up:

I need to calculate total points per Employee ID #.

Paul Newcome

@benetta.francique

I do not see a few columns in the screenshot that you have in your formula.

Date

[Today's Date]

[Incident 24 Months]

[Accident 24 Months]

Also, do you have at least 5528 rows in your sheet?

Andrée Starå

Are these all colums? There seem to be some missing from the screenshot.

benetta.francique

I am currently building this sheet, but I will have the data to put into as soon as I can figure out the formulas. I am not sure if it will be 5528 rows of data though. The date is "Date preventable confirmed". "Incident or Accident" are put in by Incident - 1 and Accident - 2. "Points received" calculates how many points they received from "Incident or Accident". "Previous point tally" will be entered manually. "Total points" calculates the total points for "Points received" and "Previous point tally". However, I need it to calculate totals for each "Employee ID #". I hope I explained that correctly.

benetta.francique

The error that I am getting is #UNPARSEABLE.

Paul Newcome

If you do not have any data in the sheet, your references to row number 5528 will throw that error.

Would you be able to populate it with a few sample rows and provide some screenshots? It sounds like a SUMIFS is in order, but I'd like to see what you're working with before committing to that.

benetta.francique

@Paul Newcome the points received auto fills from what is chosen from the "Incident or Accident". Only the "Previous point tally will be entered manually.

Paul Newcome

@benetta.francique Is that auto-fill formula the one you are looking for?

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, category/bannerUrl, category/bannerImageAlt, category/extensions, category/customizationLabels, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/bannerImageAlt, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.