I have a worksheet for team members to complete several fields in row. I want to count # of fields that are incomplete(countblank) when a date, they enter into worksheet, is greater than 02/01/2020. If the entered date is less than 02/01/2020, I don't want a count. The fields they are completing are included in the table range. Here's cell formula I'm using for this count.
=IF([@[Entered date]]>=DATE(2020,2,1),COUNTBLANK(Table4[@[Field1]:[Field10]])," ")
When a new row is inserted within the table the cell formula is blank. What am I missing?
=IF([@[Entered date]]>=DATE(2020,2,1),COUNTBLANK(Table4[@[Field1]:[Field10]])," ")
When a new row is inserted within the table the cell formula is blank. What am I missing?