Formula for 2 columns - checkbox and a date range

Asad Ullah
Asad Ullah ✭✭
edited 06/09/21 in Formulas and Functions

Hi there - newbie here. Looking for help with a formula.

I am trying to drive a metric which shows the percentage of activities on 'THD Brands' in the past week. The 'THD Brand' column is a checkbox, so essentially I need to count anything that is ticked in this column, and also the 'Last met?' column has a date within the last 7 days, divided by the overall count of all the activities that happened in the 7 days, whether they have a checkbox or not in the 'THD Brand' column.

Hopefully I have described that clearly enough ☺️

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!