List Calculated Column - Count Text

akrshaw · Dec 9, 2013

I have the following list:

File Name [tab][tab]Review 1 [tab] [tab]Review 2 [tab][tab][tab][tab]Review 3 [tab] #
001_SOC [tab]Jones/Working [tab] Nelson/Complete [tab] Haim [tab][tab][tab] 1

I need to count the number of Review columns that contain the word complete.

I need to count the number of Review columns that contain the word complete.

ehaze · Dec 27, 2013

cOne, cTwo, and cThree are my column names.

Place this string in a calculated column.
=COUNT(FIND("Complete",cOne),FIND("Complete",cTwo),FIND("Complete",cThree))

http://www.sharepointed.com/2013/12/27/count-the-number-of-columns-that-contain-a-value/

http://www.sharepointed.com/

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

List Calculated Column - Count Text

akrshaw

Programmer

ehaze

Technical User

Similar threads

Part and Inventory Search

Sponsor