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
Help Article Resources
Check out the Formula Handbook template!