Countif
I don't know if I should use the Countif or Countifs but either way, my formula isn't working for me. I'm trying to count the Progress Status of each Team member's project.
So my Source file is "Masterfile" and my column is "Progress" and each status is "Not Started" or "In Progess" or "Completed"
When I tried to do the formula:
=COUNTIFS({Masterfile HR Intake Project Sheet Range 5}, Variables@row, "Not Started")
I get error INCORRECT ARGUMENT
Answers
-
Are you able to provide some screenshots for context?
-
my graph has the correct #s but as you can see, my widgets are displaying incorrect #s.
My metric sheet is:
-
It looks like your metrics sheet has the same numbers as your chart. How exactly did you create the metrics widgets? It looks like there is data below some of the initial numbers in some of the metrics widgets. Are you able to scroll down on the metrics widgets?
-
I didn't use the widget behavior, I believe this was a template and I did cut and paste to the existing widget on teh template:
Does the Smartsheet Technical team help with questions like this?
-
Try adjusting what data is shown in the metrics widgets. It doesn't have anything to do with the widget behavior. Lets look for an example there in the "Completed" widget. See how it looks like there may be text underneath of the number 2? What's down there?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!