Creating a formula that uses the output of a formula in another column
I have column that generates a True /False answer using the formula below:
=IF(ISBLANK([Published date]@row), "", (IF([Published date]@row <= [Date due]@row, "True", "False")))
I want to work out the percentage that are "True" in a separate column.
The formula I had created stopped working a while ago and shows as #INVALID OPERATION and I can't work out why:
=COUNTIF([Within Target?]:[Within Target?], "True") / COUNT([Within Target?]:[Within Target?])
(Column was set show as %)
Is anyone able to spot where I am going wrong?
Help Article Resources
Check out the Formula Handbook template!