How to calculate a % done across a row?

Ellyn S

I'm trying to calculate $ Complete where green = 100% done; the rest indicate not done, 0%

Vendor A = 0% complete (0 green indicators of 6)

Vendor B = 33% complete (2 green indicators of 6)

I appreciate any input :=)

Kelly Moore

Hey @Ellyn S

=COUNTIFS([Initial Call]@row:[Agreement Executed]@row, "Green")/6

Does that work for you?

Kelly

Kelly Moore

Hey @Ellyn S

=COUNTIFS([Initial Call]@row:[Agreement Executed]@row, "Green")/6

Does that work for you?

Kelly

Ellyn S

Hi Kelly - Worked perfectly! Thank you!