I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows?
I also would like to make a formula for a metric sheet that automatically updates as I add and delete years from my main sheet. What formula would I use for that part as well?
I've tried a few different options and keep getting the unparseable error.