Formula for 2 columns - checkbox and a date range
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 ☺️
Help Article Resources
Check out the Formula Handbook template!