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; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Automate the Progress Bar With Multiple Dropdown

kpellecer

Hi,

This is our current formula for our progress bar:

=IF([Deployment Date]@row = "Cancelled", "", IF([Deployment Date]@row = "", "", IF(OR(COUNTIF([Copy Status]@row:[Code Status]@row, "Delivered"), COUNTIF([Copy Status]@row:[Code Status]@row, "--- N/A ---")) >= 4, "Full", IF(SUM(COUNTIF([Copy Status]@row:[Code Status]@row, "Delivered"), COUNTIF([Copy Status]@row:[Code Status]@row, "--- N/A ---")) = 3, "Three Quarter", IF(SUM(COUNTIF([Copy Status]@row:[Code Status]@row, "Delivered"), COUNTIF([Copy Status]@row:[Code Status]@row, "--- N/A ---")) = 2, "Half", IF(SUM(COUNTIF([Copy Status]@row:[Code Status]@row, "Delivered"), COUNTIF([Copy Status]@row:[Code Status]@row, "--- N/A ---")) = 1, "Quarter", IF(SUM(COUNTIF([Copy Status]@row:[Code Status]@row, "Delivered"), COUNTIF([Copy Status]@row:[Code Status]@row, "--- N/A ---")) < 1, "Empty")))))))

Currently, once something is marked as "Delivered", it completes the Progress Bar. But we currently just added the Option, "Using Code Bank", how can I add it in the formula for it to also complete the Progress Bar?

Screenshot 2026-10-21 at 11.47.02 AM.png

Find more posts tagged with

Sheets

Formulas

Automations

Accepted answers

All comments

Paul Newcome

If "Using Code Bank" is considered the same as "Delivered", anywhere you have "Delivered" replace it with

OR(@cell = "Delivered", "@cell = "Using Code Bank")

For example:
COUNTIF([Copy Status]@row:[Code Status]@row, "Delivered")

changes to

COUNTIF([Copy Status]@row:[Code Status]@row, OR(@cell = "Delivered", @cell = "Using Code Bank"))

kpellecer

Thank you!! It worked!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, category/bannerUrl, category/bannerImageAlt, category/extensions, category/customizationLabels, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/bannerImageAlt, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.