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.

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

How to automate Harvey Balls based on % Complete Summary Field

Robert Y

Hi everyone, I'm looking to find a way to automate the Harvey Balls symbols based on a % complete Summary field where the percente complete is 25% 50%, 75% or 100%. Any help is greatly appreciated.

Thanks,

Robert

Comments

Atus Bartal

Robert,

This works in a Harvey Balls symbol column (row 1):

=IF([% Complete]1 < 0.25, "Empty", IF([% Complete]1 < 0.5, "Quarter", IF([% Complete]1 < 0.75, "Half", IF([% Complete]1 < 1, "Three Quarter", "Full"))))

I hope this is what you're looking for.

Atus

Robert Y

Thanks Atus this worked like a charm.

Robert

Sign in to join the Community!

Quick Links

Find more posts tagged with

Human Resources

Sheets

Healthcare