I have a spreadsheet that I use to track progress completion based on the percentage of checkboxes that are TRUE (checked).

The formula I use for this has 3 separate references to another sheet. I do this for every project and I am looking into reducing the amount of copy and pasting I am doing when adding a new tracker. Currently I am using the below formula:

=COUNTIF('Automation: PHP Reference Parser'!A:A,TRUE)/(COUNTIF('Automation: 
PHP Reference Parser'!A:A, FALSE)+COUNTIF('Automation: PHP Reference 
Parser'!A:A, TRUE))

I am trying to replace the three instances of 'Automation: PHP Reference Parser' with a reference to a cell that already contains this string as the project name. I have attempted to do this with INDIRECT but I get a parse error in the following attempt:


1 Answer 1


Change your


to the following format.

  • This is exactly what I was looking for. Thank you!
    – Jason
    Dec 6, 2018 at 21:35

This site is temporarily in read-only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .