nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

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!

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.

Sign in to join the Community!

Quick Links

Find more posts tagged with

Sheets

Formulas

Reports

IT & Operations

Project Management