Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
If Status is "Completed" then make % Complete "100%"
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 variety of reasons, but I can't find the answer in my searches...