We’re trialling Monday.com - and generally happy but have hit a couple of major roadblocks.
I’m struggling to set up a high-level board that shows how much time we have spent on a project vs the time we allocated that task or project. And whether or not it is at risk of going over-budget (on time).
Currently, our projects each have a board and on that board are groups of tasks each with a Numbers col called ‘Allocated Time’ and then next to it a ‘Time tracking’ col.
Ideally, I’d then have a high-level board with each Project as an individual item - showing a column with the sum total of hours allocated to that project, the actual total of hours spent on it (Time Tracking) and then some sort of conditional Status column with - ‘on track’, ‘at risk’ etc.
Currently, I understand it’s not possible to link cells individually across multiple boards so am settling for a high-level board per project which isn’t ideal but maybe someone can suggest a hack where a dashboard can aggregate these.
So on the high-level board I have per project, I’m using a ‘link to’ column and ‘mirror’ col - I’ve managed to bring in the sum Allocated Time and sum Time Tracked from the lower level board. I now want to compare the two columns and automate a status based on the difference - looking at the Formula column but struggling to get this to work.
Any help much appreciated.