Cake chart based on number of taks done and not done

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!