Forum Discussion

jaolvera's avatar
jaolvera
Brass Contributor
Jul 14, 2023
Solved

Formula assistance

Hello,  I was wondering if there was formula I could use that would essentially list out any person where the calREDIE DI# column is blank (Column Au would blank), and fill each row (Photo below tha...
Formulas and Functions
  • flexyourdata's avatar
    flexyourdata
    Jul 18, 2023

    jaolvera 

     

    Yes, edit the second argument to FILTER:

     

    =LET(
    missing, FILTER(Linelist!B2:D4, (Linelist!AU2:AU4 = "")*(LineList!B2:B4<>"")),
    TAKE(missing, , 1) & ", " & CHOOSECOLS(missing, 2) & " " &
        TEXT(TAKE(missing, , -1), "mm/dd/yyyy")
)
jaolvera's avatar
jaolvera
Brass Contributor
Jul 18, 2023
thank you! that worked, if there a way to add an "if" statement that will apply this formula only if Column b has data entered?
flexyourdata's avatar
flexyourdata
Iron Contributor
Jul 18, 2023

jaolvera 

 

Yes, edit the second argument to FILTER:

 

=LET(
    missing, FILTER(Linelist!B2:D4, (Linelist!AU2:AU4 = "")*(LineList!B2:B4<>"")),
    TAKE(missing, , 1) & ", " & CHOOSECOLS(missing, 2) & " " &
        TEXT(TAKE(missing, , -1), "mm/dd/yyyy")
)
  • jaolvera's avatar
    jaolvera
    Brass Contributor
    Jul 18, 2023
    Thank you so much!!!! worked perfectly