Help with a formula

Hi! I'm having trouble figuring out a formula for the following situation.

I have a column called "date applied". I want to know how many candidates applied per day. I also would like to add to that more filters I.E. location. Meaning I want to know how many candidates applied PER DAY PER LOCATION.

Similarly I have a column called "Date scheduled" and another one called "Office Scheduled" - I want to see how many candidates are scheduled PER DAY PER LOCATION.

I hope someone can help me as I've been struggling to figure this out for a while now.

Thanks!

Tags:
«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!