How to count At Risk task to create a report?

Hi,

I'm using a template and it already allow me to flag a column when At Risk. I would like to count how many items I have flagged, but i'm not sure how.

I've used

=SUMIF({Sheet - Request Tracker with Form Range 1}, "Red")

=COUNTIF({Sheet - Request Tracker with Form Range 1}, "Flag")

Thanks for your help

Find more posts tagged with

Reports

functionality

Accepted answers

All comments

Nasir@EBC

The correct formula will be:

=COUNTIF({Sheet - Request Tracker with Form Range 1}, "Red")

Hope this helps!

regards

Nasir

Tashawn Payne

Hi Nasir, I tried that and it did not work. What I am trying to count is the Pre-Assigned Column in Smartsheets standard Grid that has the "At Risk" Flags that you can select to enable or disable the flags that turn them red. However, "Red" is not a valid Criterion to count the number of activities at risks which are flagged. Is there perhaps another Criterion I can try? I also tried "Flag" ..."Flagged" and "True" and none of them work either.

Thank you kindly.

Paul Newcome

@lewis hamilton Your response is not related to Smartsheet.

@Julio Martinez Coronado Try this:

=COUNTIF({Sheet - Request Tracker with Form Range 1}, 1)

The 1 represents a "true" value or a "flag". 0 would represent "false" or "not flagged".

@Tashawn Payne Please see above about using 1 vs 0 as a criteria for counting flags.

Todd Smelser

Hi,

I understand how to count the At Risk flags but

=COUNTIF({Onboarding Tasks Range 1}), 1)

But I am not clear on how to count other symbols. For instance I need to count the number of High Priority tasks in a sheet ("!). What would be the syntax necessary to return values for that symbol?

Paul Newcome

@TSmelser If you click on the dropdown arrow to display the options available within a cell, you are going to want to reference the text portion.

=COUNTIFS({Range}, "High")

Todd Smelser

Yes, Thank you Paul. I have no text within the drop down. Only the symbol. Am I able to add text? I did try to add HAS(@cell, "!") but still return a value of 0

I may have to resort to a simple drop down rather than the symbols

Paul Newcome

No. When you use the text in the formula, it will register the symbol.

So the column itself will show the "!", but to reference it in formulas you need to use "High".

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.