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 crossreferenced 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
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 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!