Count or Sum by row
I am working on a R, Y, G system (or 1, 2, 3 depending on which formula makes the most sense) by employee… but, I am struggling to figure out how to count the number of reds by row or to sum amounts in multiple columns within the row for some reason. For example, I have values/colors assigned for tenure and pay range columns but cannot get SUM or COUNT to work in order to count what is in those columns for each employee row.
Lindsey Marantos, PhD
Talent Programs Manager, Total Rewards
Heartland Dental
Best Answer
-
It looks like the formulas outputting the numbers are actually outputting text strings that just look like numbers. If you have quotes around numbers in a formula's output, it will output as text. If you remove those quotes, it will output as numbers and can then be added together the way you are expecting them to.
If this doesn't clear things up, please provide the formulas that are outputting the two numbers you are trying to add together.
Answers
-
Are you able to provide some screenshots for context?
-
Of course! In this visual, I am wanting to add the two yellow columns by row and have the total show in the orange column. The current formula that is giving what is currently shown in the orange column is:
=([Pay Range Penetration Flag]@row + [Tenure Flag]@row)
Thank you for your time and expertise!
Lindsey Marantos, PhD
Talent Programs Manager, Total Rewards
Heartland Dental -
It looks like the formulas outputting the numbers are actually outputting text strings that just look like numbers. If you have quotes around numbers in a formula's output, it will output as text. If you remove those quotes, it will output as numbers and can then be added together the way you are expecting them to.
If this doesn't clear things up, please provide the formulas that are outputting the two numbers you are trying to add together.
-
That was so simple! Thank you so much! It's working beautifully now :)
Lindsey Marantos, PhD
Talent Programs Manager, Total Rewards
Heartland Dental -
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 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!