Clarity on count functions

Mangesh W

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

Paul McGuinness

Hi @Mangesh W

This should do what you need -

=1 / COUNT(B@row:I@row) * COUNTIFS(B@row:I@row, "Yes")

Tested below and working

Hope that helps

Thanks

Paul

Paul McGuinness

Hi @Mangesh W

This should do what you need -

=1 / COUNT(B@row:I@row) * COUNTIFS(B@row:I@row, "Yes")

Tested below and working

Hope that helps

Thanks

Paul

Mangesh W

Hi Paul,

Thank you for your time and the answer. It worked.

I too was able to solve it, although not with the same efficiency as yours. Below is what i did..

=((COUNTIF(A@row:I@row, "Yes") * 100) / 8) + "% complete"

Paul McGuinness

HI @Mangesh W

Glad it worked 👍️ thats always the brilliance of smartsheet as there is always a couple of ways to get to the answers you need.

Thanks

Paul