Counting Blank Cells

Beronica Muller

Nope, that didn't work as well.    When I click on a cell in the Priority column, it reference the sheet.  I backspace to remove the reference sheet and still get the error message. Is there a way to do a webex because I think that I am not doing something correctly?

Paul Newcome

Is the Priority column on the same sheet as the formula?

Beronica Muller

No, it is not. I can not put the formula in Priority column because it is a select drop down column.

Paul Newcome

There's the issue then. I have been working thinking that the Priority column was on the same sheet as the formula.

You can put formulas into dropdown type columns, but if it is on a different sheet from the formula, then we need to first find a way to specify exactly which row from the other sheet you are pulling from the Priority column.

Beronica Muller

My apologies as I was not crystal clear on that. I tried to substitute the actual sheet reference in the formula and was unsuccessful. 

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJcAAAAjCAYAAACZxJgaAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAARSSURBVHhe7ZqxcrM4EMeXb+bK9LjzY+CON8Al7lx+/V1hmq+FR0jpDkrzBqSCMo/gIhlT3BV5Am5XAoyQwObOyiTz7S+jiQZLy0r6a1dK7DQIMMwDeH9/h6enJ1F/fX0F5+3tjcXFPAxFXBy5mEcxjlw/RI1hLMDiYqzB4mKsweJirDEprjrbwjarRb1KHEgqURXPnW0G8pMr6vMKEscBp+vUU0O2vdrCTrClduOi9Zuy17533J+K5qN897CNaq59h6kYxktz4jgJ9hoxMaZuLgWizRaGj64s8+MrMymu8zkHb+1irYZzFcB6LZ8vIkomJnBIAOmlAbq0ylJCHG3UxagKiOIYnxf6YhJBCpe+f2sj38HP3gYJawU7r1TawGYsMIC4HNppyykEmokrFRQR+hNHUJgdUsd0SQF2K+1dc9znx9dmQlxy8nyP6mc45x4InS0kCHBOfy7dbR7s0wDyrGj7oTCSCGJ/D+sgguS2WpGxDRoDLpgcUItsE5nVMUudJSh2H/Zr7J/cMT7XhxDnojovm4nvjiYuGZI3EOHPRqkbUsANvMNhFEH+A3UBWU5Cd8HHFboKZglrFCYG0pGQ3PAEzWEouHuoochyIVTXDyHIMyhuOSTGEEDof6e48//RxHWg8FvGFJdlKO7rB9zrS/HggP3z3XGBMCs47nIIQl+kgLrIIMcoQe92QxLrHYs5soE9IXxOIcB0251flLQ7IMJUqZxzsCjprBc71t0QDnEOmeZQjllwYGO1A688QbhAWzf9+AYY02J9riBoD1lVQSlpuax6vAOUeDbZTM7MaCEoUqKYT2IlKEoApPvu/R74psXE6LgaLIJqowWFcGrPLhdKmXgGMi2Y6awzDG4kdnSo32iej5tHi6b6OZLOd1OCNnHLj++AMS2ucNd3k7+Jul0k06K7xhHmeIaRze/C28uoYdbXeCGwdLNYHWGXq+Ijf7RIODzQU6Qlm70gdUQ6xLYksmizJN3LiNjNjSjSITjOGhmfAX8PDGkRb1r4U4rFGtbn0yLdLvF6ab7NYNR4poVMjotESVEzSC9SNH0hn6ZuaQhGSnk5G4imSozXeLFRlkC3Vu1m2mBk1s9zjCkt1meoAjwAj+sdni8WV0lzdQZ4oZtNn274DCldDVCD90E3VtMhmFLj/GKKd+HNsveRfKbUqYROeQtFp2c3zRAh9v4cd4VSIzo0EwHHZ8DfBNx5KmXcUMLX6gplg9NJ36boi9pMfq51JXvD55e0CSBoMC1qYMpqMGw1ho9aO7LfZLv2XRj52geXBoNn76/6GaGP6Vrippzxtesr7Il2BhvDyZhtc8MPaeFLQl/f+vj4EOXl5aXhr9wwD4O/csN8GiwuxhosLsYaLC7GGiwuxhosLsYaLC7GGiwuxhoO/Pk3/xGVeRgfv/4Qv/mPqIxV+N8/zENw/vpH/ObIxXwKLC7GGiwuxhosLsYaLC7GGiwuxhIA/wK6WSkZytrdHAAAAABJRU5ErkJggg==

Beronica Muller

@Paul Newcome I tried to enter the referenced sheets in the formula and that did not work as well.

=WORKDAY(TODAY(), IF({National Alliance Operation Inquiries Range 3}@row="Medium - 24 hours", 1, IF({National Alliance Operation Inquiries Range 3}@row="Routine - 48 response", 2, 0)))

Paul Newcome

We need to first establish a unique Identifier for each row. Do you have a column that contains something unique to each row, or is there a combination of columns that would designate a uniqueness across each row?

Beronica Muller

@Paul Newcome I am not sure if I needed to create a new discussion, but thought that I would try this first. Nevertheless, I am struggling with counting blank cells in a column. This time, I have been tasked to count blank cells and create a widget that would show the numbers on a daily and weekly basis. Here is the formula that I have for the weekly basis. I figured once I successfully create the totals for weekly formula, I can create a widget to display the daily totals. Are you able to assist and advise what am I doing wrong?

=COUNTIFS({Accrue Funding/Enrollment File Tracking Range 1}, ""), AND(@cell >= DATE(2021, 5, 1), @cell <= DATE(2021, 5, 31)))

Paul Newcome

@Beronica Muller Which column are the blank cells that you are counting in?

Beronica Muller

@Paul Newcome I will eventually have to count the blank cells from the Date Processed, Complete (this is a checkbox column), and the Date File Received columns.

Paul Newcome

@Beronica Muller Ok. How do we evaluate the two different date columns? Is it similar to a Start and End date kind of thing and the blanks are basically "unchecked" in the Complete column?

Beronica Muller

@Paul Newcome it is really based on the blanks in the two columns and unchecked in the Complete column.

Paul Newcome

@Beronica Muller I'm sorry, but I still don't follow. Are you trying to count blank date cells? If so, how are you supposed to establish the date range? Are you trying to count where one column is blank and the other has a date between the date ranges and the box is unchecked?

Beronica Muller

@Paul Newcome My apologies if I am not explaining it clearly. Now that you mention it, I probably needed to add a column. So, I am trying to count blank date cells in the Files Processed and Date Files Received column. I also need to count the unchecked boxes in the Complete column. To get my results on a monthly weekly basis, I will need to compare the date based on the Date File Expected column. Is that more clear?

Paul Newcome

So you want to count rows where the box is unchecked, Files Processed is blank, and Date Files Received is blank based on a date range looking at the Date File Expected column?