Get average of a column if another column is checked?

Hi everyone!

I was hoping to get assistance on writing a formula.

I was wondering if there's a way to get the average of numbers "RWA Accepted to NTP Actual" if "FY20 RWA" column is checked? Thank you!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!