Sign in to join the conversation:
I would like to count how many of my orders do not have PO number (i.e Po Number cell is blank)
Can you help with the formula to do this
Thanks
Try this formula.
=COUNTIFS([PO Number]:[PO Number], ISBLANK(@cell))
Make sure your column title is PO Number. If it's different update my formula to match.
I would suggest adding in additional criteria for another column that is always populated. That way your formula doesn't include the blank rows at the bottom of the sheet.
If you have a date type column that will always have a date in it regardless of whether or not there is a PO Number, you could use something along the lines of...
=COUNTIFS([PO Number]:[PO Number], ISBLANK(@cell), [Date Column]:[Date Column], ISDATE(@cell))
Hi all! Happy Thursday. I have a formula that I created that is looking to calculate a number of cells that meet the specified criteria on a particular cell that inputs a date when a box is checked through an automation. What I am noticing however is that the formula is calculating items that are earlier than the specified…
Hi - We have a formula in a sheet =IF(Status@row = "Closed", TODAY(), "") That when the status at the row changes to closed, it was to add todays date in the Date Closed Column. However, it seems that it is now changing the date for anything previously closed to the current date. We need it to change it to the date when…
I am trying to move more of my Grids over to Table View, but am not able to find a way to reference another sheet in Table View, aside from using the Dynamic Dropdown option, which is not what I need, since I'm working with formulas. Is this available in Table View? I haven't been able to find anything on it.
