Hello,
I have a board that I want to use to track jobs submitted against a “Class Code” which is a prepaid amount that can be spent across multiple jobs. Each “Class Code” is an item and it has a “Max Cost” column. Every time a job is submitted, a sub item is added to the item with a job name and the cost of the job. I have added a “Roll Up” column that sums the “Cost” of all the sub items as “Total Spend”. I want to be able to change the Item’s status to “Inactive” when the sum of all the items sub items “Cost” >= Items “Max Cost” but I cannot seem to do this because the “Roll Up” column is not available in the Workflow. Anyone got any ideas how to do this??
