I'm relatively new to SF but gaining steam quickly. I've got Opportunities that include a contract start date and contact end date and I am trying to create a report that summarizes who we have contracts with in a particular year.
I added contract start date to the grouping field and grouped by year which worked for the most part. The issue I am having is with the length of our contracts. Some are for multiple years and therefore aren't showing up in certain groups. For example if a contract is from 2015-2018 it won't show up in 2016 because I've grouped it by start date, which makes complete sense.
I've poked around with formulas but keep getting the error that my fields don't exist and I'm not even sure which formula I could use or if this is the right avenue to be taking.