Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula to show monthly count
Hi, I am trying to figure out a formula that tells me how many entries have been entered for a particular month. I have a date column and an tonnage column so if I have 10tonne of material made on 1st February i would enter in the date column 01/02/16 and next to it in the tonnage column I would enter 10. I also have a total tonnage for February column, total tonnage for March column and so on for the whole year. I am trying to figure out a way to get the amount of tonnage entered for february listed in my total tonnage for february column as the amount of entries. For example if I had 6 entries under the date column listed as february I want the total tonnage for February to say 6. Any ideas on formulas for this one at all?
Many thanks, Irene