Percentage of "Yes" Values in a Month

I have a sheet that includes a column (named "PTP") of Yes/No data.

I need a sheet summary formula that will calculate the percentage of "Yes" answers in that column, across rows that fall within a calendar month, per a date in a different column (named "Actual Start").

Said another way, I need this formula to search [Actual Start] for dates between the first and last days of a given month. I would then like it to tell me, within the identified range of rows, what percent of those [PTP] values = "Yes".

Can anyone help?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!