Update triggered on completion of a subtask

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 Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!