A couple countif formulas

I have a couple formula questions:

  1. I want to count the number of employees hired from 1/1/21-until today (and have it update to be today in real time moving forward). So far I have =COUNTIFS({GB Users Source Sheet Range 1}, @cell = "Active", {GB Users Source Sheet Range 5}, "Full Time", {GB Users Source Sheet Range 4},
  2. I want to count the number of rows with a status of "In Budget" and with info coming from another column which have "GBA" selected.

Thank you!!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!