I am trying to create a formula that will return different values based on multiple factors, and the information on the sheet is linked in from another sheet
my sheet is attached and the formula I am trying to use is below. Any help is greatly appreciated
Here is my formula
=IF([% Complete]1 = 1, "complete",),if(and([% Complete]1<1,[ESD]1>Today()),"Not Started"," "),If(and([% Complete]1<1, [ESD]1<Today()),"delayed"," "),if([Internal Deployed]1=true,"Internally Deployed",[ECD]1),If([External Deployed]1=true, "Externally Deployed",[ECD]1)
Regards
Michelle
