Automatic Formatting between 2 Columns

ClaireWallace

Hello,

Can I have a Status Cell (Drop-Down List) be automatically updated to "Complete" when a "% Complete" column is changed to 100%?

Thanks!

jpaul

Good afternoon Claire,

You can easily accomplish this with a sheet automation. Please see screen shot for the set-up.

jpaul

Good afternoon Claire,

You can easily accomplish this with a sheet automation. Please see screen shot for the set-up.

ClaireWallace

Thank you!