Remove "False" from Linked Cell for Count in Pivot Table

I have a document with check boxes and linked cells. I want the word "FALSE" to not show when the check boxes are unchecked because it is being counted in my pivot table. I need only TRUE to appear and unchecked to clear the linked cell so the counts in my pivot table are accurate. Right now the pivot table is counting TRUE and FALSE.

Welcome to the Forum blambert14!

You should create a formula in another cell that refers to the linked cell, and use that in the pivot table instead of the linked cell.

=IF(A1=FALSE,"",A1)

If that is not clear, then please attach your file. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.