Formula with symbols
I am trying to create a dashboard the will track information from 5 different sheets. I am trying to make a metrics that will count arrows. Each arrow means something else and I want the customer to know how many of the different arrows they have. My metric page will reference each sheet with the sum of the different arrows for each sheet. How do I accomplish this?
I hope someone understand what I am trying to accomplish here.
Best Answer
-
Hi,
To count symbols you use a countif or counifs function. Each has a value. See the link below. As an example, to count the up arrows in a column titled Arrow you would use =COUNTIF(Arrow:Arrow, @cell="up").
Help?
Mark
https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi,
To count symbols you use a countif or counifs function. Each has a value. See the link below. As an example, to count the up arrows in a column titled Arrow you would use =COUNTIF(Arrow:Arrow, @cell="up").
Help?
Mark
https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thank you for all your help with this.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!