List Calculated Column - Count Text
List Calculated Column - Count Text
(OP)
I have the following list:
File Name Review 1 Review 2 Review 3 #
001_SOC Jones/Working Nelson/Complete Haim 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.
RE: List Calculated Column - Count Text
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-n...
http://www.sharepointed.com/