🏆 Institution Alerts Notification - Google Sheets

Nice idea. I’ll try out this dual purpose Transactions cell A1, that first checks uncategorized transaction count. Once all categorized, the institution alert gets displayed.

=if((countifs(INDIRECT("$D$2:$D$100"),"") > 0),(
   countifs(INDIRECT("$D$2:$D$100"),"")),(
   {HYPERLINK("https://docs.google.com/spreadsheets/d/1_eD-uLs0FVM5BVCs5OGIYXqDbJaptH-BSDGzZy_C3v0/edit#gid=181597333","Alerts");SORT(UNIQUE(
      IFERROR(LET(results,BYROW(SORT(UNIQUE(INDIRECT(LET(ltr,SUBSTITUTE(ADDRESS(1,MATCH("Institution", Accounts!$A$1:$1,0),4),1,""),"Accounts!$"&ltr&"$2:$"&ltr)))),
      LAMBDA(
         institution,
         IF(institution="","",
            LET(institutions,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_eD-uLs0FVM5BVCs5OGIYXqDbJaptH-BSDGzZy_C3v0/edit#gid=181597333","Dashboard!A5:A"),
            REGEXREPLACE(IFNA(FILTER(institutions,SEARCH(institution,institutions)))," \([0-9]+\)","")
            )
         )
      )
   ),FILTER(results,LEN(results)>0)),"No Alerts")
   ))}
))
2 Likes