Duplicate Helper column with filter

T.Shuya

You did it again! Thank you!!!

T.Shuya

Hi. I'm thinking it's not working for me because sometimes the status is blank. I'm not really sure but it still doesn't seem to be working. I've gone through and made sure the formula matches my columns as well.

Samuel Mueller

@T.Shuya Try this then

=IF(OR([Deliverable Type]@row <> "Invoice", Status@row = "Completed"), 0, IF(COUNTIFS([Job Number]:[Job Number], [Job Number]@row, [Deliverable Type]:[Deliverable Type], "invoice", Status:Status, OR(@cell <> "Completed", @cell = "")) > 1, 1, 0))

T.Shuya

Success!!!! Thank you so much! You've been such a help.

Samuel Mueller

Good to hear, hopefully it continues to work this time 😁