Trying to count multiple columns IFBLANK or Not

[JWYCSean]

I am attempting to count multiple columns that will be filled with different information/values/text. If all of the Columns are not blank, I want the column to report out as "Done" otherwise, the column can stay blank or report out as "Not Done". Every IF or BLANK formula I try seems not to work and since it's in a table, I can't use a Spill range either. Here is the formulas I have tried. Any insight into how to have this report the right information or any other suggestion are welcome.

'=IF(NOT(ISBLANK(A3)),A3,IF(NOT(ISBLANK(B3)),B3,IF(NOT(ISBLANK(C3)),C3,IF(NOT(ISBLANK(D3)),D3,IF(NOT(ISBLANK(E3)),E3,"Done"))))
'=IF(A5<>””,A5,IF(B5<>””,B5,IF(C5<>””,C5,IF(D5<>””,D5,IF(E5<>"",E5,”Done”)))))

 

[JWYCSean]

No, currently the only formulas are in F4 and F5 as I was just trying to test it out before applying it to the rest of the sheet. It is just the x in A4, and the corrected formula in F4 and F5

 

[JWYCSean]

No, there is just a text "x" in A4 and the correct formula in F4 and F5.

 

[Fluff]

In that case try

=IF(COUNTIFS(A5:E5,""),"","Done")

 

[JWYCSean]

In that case try

=IF(COUNTIFS(A5:E5,""),"","Done")

Outstanding, that did. Thank you so very much. That will get me out of work on time today!

 

[Fluff]

Glad to help & thanks for the feedback.