Cake chart based on number of taks done and not done

M. Lewandowski

Hi everyone

I got column Chart counting . I would like to have formula there which put 1 if "done" column is checked and 0 if is unchecked.

I need some column which count which task are closed and which are not to create chart. My idea was to add column Chart counting and take data from there. Many you have another better idea. I would like to create chart which based on "done" column and it will show how many tasks are done how many tasks are not done and show it on the chart. In addition information about total number of task will be also very helpful .

Best regards

M. Lewandowski

Ok, this one is working

=IF(Done@row <> 0; "1"; "0")

Andrée Starå

Hi Martin,

Glad you got it working!

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!