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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!