Count Ifs Formulas

edited 12/09/19 in Formulas and Functions

I have created formulas to count the number of incoming quotes by month and according to if they have been Won/Lost/Pending. I use the exact same formula for March (month 3) and it works beautifully. For some reason the formula is not pulling in the info we have loaded up so far in April:

=COUNTIFS([Conversion Status]:[Conversion Status], "Pending", [Date Requested]:[Date Requested], MONTH(@cell) = "4", Year:Year, "2018")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!