I have an Active Engagements board on Monday and linked to it is all of our project boards, we have a mirror column in the Active Engagements Board called Remaining Schedule which is pulling from all the project boards the Billable Remaining column from all groups in that board.
The Billable remaining is a formula column with the following formula, {Days Remaining} * {Daily Billable}.
Challenge:
On the Active Engagements Board I only want it under Remaining Schedule to bring in the Billable remaining from all boards for the August and September Group in the Project boards and not all the groups on the project boards how can I do this?
I have tried to create a helper column using the following in all project boards:
“August”, IF(CONTAINS(GROUP(), “September 2024”), “September”, “”))
On Active Engagements board created a formula column:
SUM(COLLECT({Linked Items}, {Relevant Month}, “August”)[{Days Remaining}{Daily Billable}]) + SUM(COLLECT({Linked Items}, {Relevant Month}, “September”)[{Days Remaining}{Daily Billable}])
However it says A column named “{{columnName}}” doesn’t exist in this board.
Would appreciate any help