Forum Discussion
mgaut341
Helper II
1 year agoCounting 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...
- 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.
mgaut341
Helper II
1 year agoI was not able to get it to work, so I used a subtraction formula from the other result status' to get my correct answer.
v-saisrao-msft
Community Support
1 year agoHi mgaut341,
Glad your issue has been resolved. Please mark your reply as the solution, as it will help other community members.
Thank you.