have a client deliverable of 76. I want to have a dashboard widget that counts down against that number when line items in a board are marked as “Live”. This is to provide visibility against many campaigns that will be associated with this 76 total deliverable. I couldn’t find a formula widget. This is how I would build it if I was using Excel. I’d like it to look like a number widget where you can just see the number decrease as we confirm deliverables from the board
If you are saying that clients has 76 Deliverables(Line Items/Tasks) and when you mark live it should show them on Dashboard that 75 are in working and 1 is Live.
You can do that by doing this.
- Add one column, name it tasks no# and and when item is created set value to default 1
- Add automation when task is marked as Live then set tasks no# as 0.
Now in dashboard show them a chart , on X axis project name on Y axis select Count and Task No column like below:
