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
Answers
-
Ok, this one is working
=IF(Done@row <> 0; "1"; "0")
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!