Forum Discussion

mgaut341's avatar
mgaut341
Helper II
1 year ago
Solved

Counting blank fields based on another column

I am trying to count how many blank cells I have in my 'status' column when my 'appt date/time' field has a value in the cell. I have tried the following formula CALCULATE(COUNT('CCHHS Imaging & Pr...
  • mgaut341's avatar
    mgaut341
    1 year ago

    I was not able to get it to work, so I used a subtraction formula from the other result status' to get my correct answer. 

Rupak_bi's avatar
Rupak_bi
Super User
1 year ago

Hi mgaut341 ,

unable to get the sample data. However, to solve this,

Create a calculated column with below syntax and get a sum. 

column = if(and(date/time <> blank()   ,   status = blank())  , 1, blank())

this flag column should put 1 in case of status blank and date/time not blank. 

then you need to sum it up. 

Let me know if this works. Else, share sample data