If N/A checkbox is marked note % complete as 100%?

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!

Find more posts tagged with

Sheets

Formulas

Reports

IT & Operations

Project Management

Comments

Tim Meeks

Here are some ideas:

https://community.smartsheet.com/discussion/one-click-task-completion

John Hammond

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.