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 N/A checkbox is marked note % complete as 100%?
Options
I have a "Not Applicable" and a "% Complete" column. I would like to create a formula that will automatically set the % complete to 100% if the Not Applicable checkbox is marked. Any suggestions?
Thank you!
Comments
-
-
Here is a formula that will show 100% if the corresponding checkbox is checked:
=IF([Not Applicable]2, 1, 1)Keep in mind if your percent complete column is associated with dependencies, you will not be able to add formulas to it.
This discussion has been closed.
