@SudeepGhatakNZ when using the null as expression is actually bringing the whole table, however, my condition on the excel table is like below for Sydney, Brisbane, Adelaide, Melbourne and Perth, each state has a different approver
=IF(COUNTIFS(F:F,"Sydney",H:H,TODAY())=0,"Null",IF(COUNTIFS(F:F,"Sydney",H:H,TODAY())=1,"Partial","Ok"))
the table looks like:

I need to trigger an email at midday if the field is "Null" and another one at the end of the day if the field is "Null" or "Partial"