Formula that counts the total of red dot symbols in my status column
Hi everyone, I have a project plan with several rows. There's a STATUS column in which traffic lights colours (gray, green, yellow and red) appear depending on the closeness of the task to its deadline.
In another sheet, I'd like to link a cell to the STATUS column and use a formula that counts how many red dots there are in the project plan. Does someone know a formula that works for that?
Best Answer
-
You will want to setup a cross sheet reference to be able to access the information from your source sheet. Your formula would then be something similar to:
=COUNTIF({Status}, "Red")
Where {Status} is your label for the reference to the source sheet.
Answers
-
You will want to setup a cross sheet reference to be able to access the information from your source sheet. Your formula would then be something similar to:
=COUNTIF({Status}, "Red")
Where {Status} is your label for the reference to the source sheet.
-
Hey Carson, thank you for the quick answer! What's a cross sheet reference?
-
Hang on, I've found something on YouTube. All good, thanks!
-
👍️
Just respond back if you need any help getting it setup.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!