We 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 boards.
=76-countif(B:B=“Post Live”)
Any recommendations?