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

Darnelle Talamantes

 

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! 

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.