How to calculate number of text occurrences in column and return a number
Dan Harris
✭✭✭✭✭
I am trying to calculate when a Y appears in a specific column and return the number 2 when this occurs and 0 when is N, any ideas on best formula have been pulling hair out!!
Thanks
Tags:
Answers
-
Hi Dan
I assumed this wasn't a cross-referenced sheet
=IF(UPPER([Your column name]@row) = "Y", 2, 0)
The UPPPER function will force all entries to be viewed as capitalized letters. The false function will default to a blank cell if we left the last comma and zero out of the equation. As written, any false will return a zero.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!