I have merged the Two Queries to convert the 1 of the Column values (which are dates) into check and Uncheck.
If column has date it will be check anf if its empty it will uncheck.
=ARRAYFORMULA(QUERY({DATA!A3:BB},IF(ISDATE_STRICT(QUERY({(DATA!G3:G)})), "Check", "Uncheck")}, "SELECT Col1, Col2, Col3, Col4, Col5, Col6, Col7", 0))
your help will be much appreciated.
>Solution :
Please try:
=ARRAYFORMULA(QUERY({DATA!A3:BB,IF(ISDATE_STRICT(DATA!G3:G), "Check", "Uncheck")}, "SELECT Col1, Col2, Col3, Col4, Col5, Col6, Col7", 0))