COUNTIFS range formula while referencing another sheet

Ashley B.
Ashley B.
edited 06/16/22 in Formulas and Functions


I am unable to figure out how to count the total number of cells that are in a certain status AND range between 31-60 days while referencing another sheet. I have used the formula below to get a total when a cell is in the "Assiged" state AND is less than 30 days and it worked. I've also provided a screenshot of the two columns that I'm working with.

Here is the formula for the less than 30 days and in the Assigned state:

=COUNTIFS({Referenced Sheet Range 1}, "Assigned", {Referenced Sheet Range 2}, "<=30")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!