Hi, I thought I had my formula right and using the proper one for this case but I'm not getting any data pulled and I know there is data that should be coming back.
Purpose, I'm trying to count the number of times the header was used as source for the appointment scheduled. The data for the source is in another tab and that will be updated frequently, but this should not change the count I'm looking for.
Here is the formula I am using:
=COUNTIFS(Deals2025[Deal - Deal created],[@Week],Deals2025[Ad Source],DailyLeadsTBL[[#Headers],[Meta]])
Here is the set up for the location where my formula is at:
These are the columns where I'm pulling the source by appointment date to get a count. Notice there is a space before the Ad source which is from a data validated list so when I pull into a pivot table, I can take out sum or count of. I'm hoping this is not the cause of my issue but if so please let me know.
As you can see, Jan 1 there is 3 PPC created via but Column X is coming back as 0. What am I missing here? I'd appreciate any input or advice to help get me unstuck.
Purpose, I'm trying to count the number of times the header was used as source for the appointment scheduled. The data for the source is in another tab and that will be updated frequently, but this should not change the count I'm looking for.
Here is the formula I am using:
=COUNTIFS(Deals2025[Deal - Deal created],[@Week],Deals2025[Ad Source],DailyLeadsTBL[[#Headers],[Meta]])
Here is the set up for the location where my formula is at:
These are the columns where I'm pulling the source by appointment date to get a count. Notice there is a space before the Ad source which is from a data validated list so when I pull into a pivot table, I can take out sum or count of. I'm hoping this is not the cause of my issue but if so please let me know.
As you can see, Jan 1 there is 3 PPC created via but Column X is coming back as 0. What am I missing here? I'd appreciate any input or advice to help get me unstuck.