Calculating average % based on column value

I have some numbers coming in a column from a calculation. I am targeting 60 or less to be 100%. If the If> than 60, then this is 0%. I then want the average % for each month. Would anyone be able to assist with such formulla?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!