how do i do a formula to count two different variables?


Hi, I am trying to create a formula that will give me a count if two different variables are true:

I have 2 different columns 'Resource' & 'Status' I need to pull data that will portray how many jobs a person has when the status is 'in studio'

i.e for 'k' should read 1 as it's in studio but for 'j' it should read 0

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!