TL;DR: / SUMMARY
How to get critical path & slack in coda. If “Build manually” => MANY formulas => Slow coda even by splitting in many docs.
If “Use zapier” => I have MANY docs + Two (four) Zaps x doc => Not sustainable
I’m looking for a way to implement a Project management system in Coda.
My problem is that the concept of Critical Path and Slack for me are crucial in order to plan and execute correctly my projects.
(I come from Microsoft Project. I shifted because I badly need a system that could account for other variables, a well integrated system, hence Coda and its beautiful relational databases)
Use a Project Management template:
I could not find one that included Critical path & Total Slack
Build one from scratch:
I’m already planning on splitting my projects into many document in order to keep then snappy and fast, enough, because I use A LOT of columns and rows.
My problem with building manually this system is that I’m afraid the many formulas needed would slow down the docs, forcing to split the project into even more documents, going beyond reasonable number
Use zapier + clickup
That was my initial plan until when I found out that every zap is associated to one single document. Creating multiple zaps (create row, receive from clickup slack & critical path data) for every single document would be unsustainable , since I plan to use dozens of docs if not even more
Still haven’t planned how but a Clickup pack would definitely allow me to find a reasonable workaround, but unfortunately it has not been built yet
Use MS Project + Coda via CSV import
After trying for a bit I quickly realized that this method was slowing my workflow in an unacceptable way
Has any one found a system / method / trick to get critical path & total slack time in Coda?
Thank you to anyone that will take the time to respond!