Update triggered on completion of a subtask

James Chestnut

Hi all,

I need some help changing the status of an item to 100% when the first subtask for that Item in another sheet is completed.

The working sheet has the following columns and I'm trying to update the "Complete Percentage" column

The Target sheet has the following:

So when the 1st subtask of "General Arragement Drawings" reaches 100% , regardless of which is actually first, I'd like the "Complete Percentage" for "1st Module GA issued" to go to 100%.

I'm using the following formula for items that do not have subtasks.

=VLOOKUP([Description of Work]@row, {JAX LNG - Project Tracker Range 3}, 18, false)

best,

James

Genevieve P.

Hi James,

If you're just looking to see if any of these child tasks says "Complete", then you can use a formula to see if that specific range CONTAINS the word "Complete" anywhere... try this:

=IF(CONTAINS("Complete", {General Arrangement Status}), 1, 0)

Keep in mind that the cross-sheet range, {General Arrangement Status}, would just be for the selected child-rows status column, like this:

Is this what you were looking to do? Let me know if this works for you!

Cheers,

Genevieve

Genevieve P.

Hi James,

If you're just looking to see if any of these child tasks says "Complete", then you can use a formula to see if that specific range CONTAINS the word "Complete" anywhere... try this:

=IF(CONTAINS("Complete", {General Arrangement Status}), 1, 0)

Keep in mind that the cross-sheet range, {General Arrangement Status}, would just be for the selected child-rows status column, like this:

Is this what you were looking to do? Let me know if this works for you!

Cheers,

Genevieve

James Chestnut

Thanks Genevieve, that did it; I think I was over-complicating it.

best,

James

Genevieve P.

No problem at all! 🙂