Hello,
I'm trying to compare four columns. I've attached a short example with my formula under the Overall Status column. Here is my formula for discussion if others cannot see attachment
=IF(A2="TRUE",IF(B2<>"",IF(C2<>"",IF(D2="Complete","Done","Pending"))))
A2____B2__________________C2____________________D2
True___6/18/2019 7:00:00 AM__7/17/2018 7:00:00 AM __Complete
True_______________________7/17/2018 7:00:00 AM __ Submitted
True __7/17/2018 7:00:00 AM _______________________Submitted
True___6/18/2019 7:00:00 AM__7/17/2018 7:00:00 AM___Submitted
I keep getting the result FALSE when it needs to provide Done or Pending.
Getting frustrated because I cannot see what is wrong with my formula.
Your assistance would be greatly appreciated.
Bev
Bookmarks