Hi. I need to complete this formula:
=COUNTIF([Team Member]:[Team Member], "Joe") and Status <> "Complete" or "Not in Scope".
What is the recommendation to determine how many outstanding tasks Joe has? Thank you.
Hi @PMOGal
I hope you're well and safe!
Try something like this.
=COUNTIFS([Team Members]:[Team Members], "Joe", Status:Status, OR(@cell <> "Complete", @cell <> "Not in Scope"))
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
@PMOGal You'll want to use COUNTIFS for this, as this function allows you to specify multiple criteria.
=COUNTIFS([Team Member]:[Team Member], "Joe", Status:Status <> "Complete", Status:Status <> "Not in Scope")
In English: Count rows where Team Member = Joe, and where Status is not Complete nor Not in Scope.
Hi Andree/Jeff: I am getting an UNPARSABLE error with either formula. [Status], like [Team Member] is a column heading. Do I need the [ ] around Status? I tried that, too, and I still get unparsable.
@PMOGal
Strange!
Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing)
Hi Andree / Jeff: I took another stab and Jeff's formula. It is working now! Thank you both for your help.
Excellent!
You're more than welcome!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
Sorry, I'm back. Apparently, Smartsheet is not counting tasks (in Jeff's formula above) if the Status ISBLANK. How do we incorporate this?
Please cancel. I appear to have a browsing issue. My report is correct, my dashboard is not. Going to clear browser data.
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.
