Line in the plan (In scope formula) checkbox use case:
In simple terms I’m looking for a formula if a Row ID is above a given Row, the product task is in scope (Out of Scope checkbox column/row is unchecked) and if the Row ID is below the “Out of Scope Below” row ID, then the out of scope checkbox is checked.
Need:
I have a blueprint project plan that has a list of potential products that can be part of a clients project.
Each product starts it’s project plan life below the out of scope line and the out of scope checkbox checked. Each product has a list of tasks that get moved above the “Out of Scope Below” row ID when a deal is closed with a client and that product is in scope.
I want the out of scope checkbox to automatically be cleared when the items move above the line and I want the out of scope checkbox to be set when the product task is moved below the line.
I’m looking for a formula that is linked to a row ID number, however that row id number will change as product tasks get moved above or below the line.
e.g. the “out of scope below” row ID can start out as Row ID number 100 but it can be changed to row 200 (or any other number) as product tasks get moved above the line.
Any recommendations on how I can use the Row ID value linked to a formula?
