How to fix my #Boolean Expected Error
Good morning, I'm trying to solve this error in my formula. All I want to do is display a % complete every time I click a check mark under my done column. Here is my formula:
=COUNTIF(Done:Done, 1) / (COUNTIFS(Done:Done, 0, Tasks:Tasks, NOT(ISBLANK(@cell))) + (COUNTIF(Done:Done, 1)))
https://us.v-cdn.net/6031209/uploads/051/4Q2R6HSO2865.png
Any help will be greatly appreciated!