Formula referencing multiple criteria


I am a little stumped on where to start with this one. I have where I want this sheet to count each of the columns of another sheet if certain criteria are met. For instance, I want to know the sum of Beginning Case Load - Active Status if the role is nursing and the date helper column is 2/2/24 (the return response should be 10).

Formulas are not a strong point for me, I am trying to learn.

I want this to calculate on a separate sheet.

Here is the destination sheet

Here is the source sheet

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!