Trying to write a sum equation, but summing text and not numbers
So we are using the letter I (that's a capital i) to tally the number of times we assign something in a different system (very antiquated system, but it's the only way to do it right now), and I am trying to sum the total of assignments. We currently do it in excel, but the same logic is not following in SmartSheet. Here is an example of the table. So each "I" needs to be counted as a separate unit, but when there are multiple in the cell, I don't know what to do. Can someone suggest the best method to pull either do a SUM or a COUNT?
Answers
-
Hi @Elizabeth Sullivan ,
It's not pretty but the:
=COUNTIF([Monday (3/29)]:[Friday (4/2)], "I")+(COUNTIF([Monday (3/29)]:[Friday (4/2)], "II")*2)+(COUNTIF([Monday (3/29)]:[Friday (4/2)], "III")*3)
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!