Insight formula
Content
Hi there,
I am trying to set up weekly reports for my company and hoping someone can help me with one of my formulas. I have attached the summary report I have set up and added notes. I basically need to know what formula to use in order to say “if the position is Open and it is a New position, then count as 1”, I currently use Countifs in excel to do this. I would also like to know how I can use the average aggregate function but only average Open positions for Average Days Open and Filled positions for Average
0