I need help with the formula to automatically make the % Complete be 100% for any row where Status is "Completed"
Do I put the formula in the % Complete cell? And if so, what formula? What I have tried so far does not work:
That's probably wrong for a