# Need help with a formula.

Options

So I am trying to make a formula that encompasses 3 completion statues. So I have 3 fields that will all get marked to 100% and I want a main completion column to up date when the others hit 100%. So when Column A hits 100% then column D will be at 33%, then when column b hits 100% column D will update to 66% and then when column C hits 100% column D will finally update to 100%. But everything I keep trying isn't working. I have tried it with IF/OR, IF/AND, etc. Not sure what I am missing. This is basically what I am trying to do in one formula. IF([Building Completion %]@row = 100, "33%") IF([Building Completion %]@row = 100, AND [Testing Completion %]@row = 100, "66%") IF([Building Completion %]@row = 100, AND [Testing Completion %]@row = 100, AND [Client Testing Completion %]@row = 100, "100%"). Thank in advance for help!

Tags:

• Overachievers
Options

@Dustin AK Lean VA Try this. Update a@row etc. to whatever you column names should be.

If( sum(a@row, b@row, c@row)>=3, 1, If( sum(a@row, b@row, c@row)>=2, 0.66, If( sum(a@row, b@row, c@row)>=1, 0.33,0)))

• Overachievers
Options

@Dustin AK Lean VA Try this. Update a@row etc. to whatever you column names should be.

If( sum(a@row, b@row, c@row)>=3, 1, If( sum(a@row, b@row, c@row)>=2, 0.66, If( sum(a@row, b@row, c@row)>=1, 0.33,0)))

• Options

Thank you! This worked, I totally forgot about doing it from greatest to least.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!