Creating a %Complete Field based on selections in several single-select fields

Topic Labels: Formulas
Jump to Solution
2538 11
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect

Hi all!

I’m trying to create a %Complete column in a project table that includes several single-select fields used to track 1. whether or not a particular team has tasks associated with the project, and 2. what that team’s progress is on those tasks if so.

I’m thinking what I need to do is create a formula column for each one of these, assigning a number to the values selected, a column that totals these up, and a column that calculates the % complete by dividing the total complete by the total that needs to be complete.
Maybe use the SWITCH formula to assign numeric values?
I just don’t know how to set up conditional formulas that complex at this point. Can anyone help me?

Thanks very much!

11 Replies 11

Hurray!!! That did the trick! Thank you so much! This will be great!

7 - App Architect
7 - App Architect

As a bonus for anyone that’s interested in replicating, here’s a shot from the interface I built for this: