Clarity on count functions

Hello reader, this is a new smartsheet user here.

Question - Is there a way to calculate count of a specific value in a range of row cells for columns which have a symbol data type and use that same count for an arithmetic operation?

Detailed Description - in below screenshot I want to count the number of "yes" in a specific row from column B till column I and then use that same count to calculate percentage in column A.

Example - Like ColumnA row1 should reflect 100% complete as it has 8 out of 8 "yes" symbols and ColumnA row3 should reflect 25% complete as it only has 2 "yes" symbols out of 8

Best Answer