List validation formula for multiple conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-3276030%22%20slang%3D%22en-US%22%3EList%20validation%20formula%20for%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3276030%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20figure%20out%20how%20can%20I%20write%20the%20formula%20if%20I%20have%20multiple%20status%20drop%20downs%20that%20need%20to%20have%20different%20columns.%20For%20instance%3A%3C%2FP%3E%3CP%3EStatus%20%22Under%20Review%22%20needs%20to%20display%20the%20field%20%22Request%20Initiated%20Close%20Date%22%20and%20if%3CBR%20%2F%3Estatus%20%22Case%20Opened%22%20need%20to%20display%20the%20field%20%22Under%20Review%20Close%20Date%22%20and%20if%3CBR%20%2F%3Estatus%20%22Resolution%20in%20Progress%22%20need%20to%20display%20the%20field%20%22Case%20Opened%20Close%20Date%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20currently%20have%3A%3CBR%20%2F%3E%3DIF(OR(%5BStatus%5D%20%3D%20%22Under%20Review%22%2C%20%5BStatus%5D%20%3D%20%22Waiting%20for%20Customer%22)%2C%20IF(ISBLANK(%5BRequest%20Initiated%20Close%20Date%5D)OR(%5BStatus%5D%20%3D%20%22Case%20Opened%22%2C%20IF(ISBLANK(%5BUnder%20Review%20Close%20Date%5D)OR(%5BStatus%5D%20%3D%20%22Resolution%20in%20Progress%22%2C%20IF(ISBLANK(%5BCase%20Opened%20Close%20Date%5D)%20false%2C%20true)%2C%20true)))%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI've%20been%20trying%20for%20hours%20to%20get%20this%20to%20work%20but%20haven't%20had%20any%20luck.%20Any%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3276030%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3276236%22%20slang%3D%22en-US%22%3ERe%3A%20List%20validation%20formula%20for%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3276236%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1347354%22%20target%3D%22_blank%22%3E%40zeusPH%3C%2FA%3E%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20should%20have%20been%20more%20clear%20in%20my%20post.%20I'm%20doing%20it%20at%20the%20list%20validation%20settings%20because%20I%20need%20%22Request%20Initiated%20Close%20Date%22%2C%20%22Under%20Review%20Close%20Date%22%2C%20and%20%22Case%20Opened%20Close%20Date%22%20to%20be%20required%20fields%20when%20the%20user%20selects%20certain%20statuses.%20From%20my%20understanding%20the%20only%20way%20to%20do%20this%20is%20in%20the%20list%20validation%20settings.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3276053%22%20slang%3D%22en-US%22%3ERe%3A%20List%20validation%20formula%20for%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3276053%22%20slang%3D%22en-US%22%3E%3CP%3EBetter%20to%20set%20conditional%20formula%20for%20each%20field.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20example%3A%3CBR%20%2F%3EIn%20column%20%22Request%20Initiated%20Close%20Date%22%20edit%20the%20conditional%20formula%20for%20this%20field%20only%20put%3CBR%20%2F%3E%3DIF(%5BStatus%5D%3D%3D'Under%20Review'%2C'true'%2C'false')%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20this%20for%20each%20column%20based%20on%20the%20required%20values%20for%20Status%20field.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3276052%22%20slang%3D%22en-US%22%3ERe%3A%20List%20validation%20formula%20for%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3276052%22%20slang%3D%22en-US%22%3E%3CP%3EAre%20you%20doing%20this%20in%20a%20calculated%20field%20or%20putting%20the%20code%20in%20a%20conditional%20formula%20for%20each%20columns%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I'm trying to figure out how can I write the formula if I have multiple status drop downs that need to have different columns. For instance:

Status "Under Review" needs to display the field "Request Initiated Close Date" and if
status "Case Opened" need to display the field "Under Review Close Date" and if
status "Resolution in Progress" need to display the field "Case Opened Close Date"

 


I currently have:
=IF(OR([Status] = "Under Review", [Status] = "Waiting for Customer"), IF(ISBLANK([Request Initiated Close Date])OR([Status] = "Case Opened", IF(ISBLANK([Under Review Close Date])OR([Status] = "Resolution in Progress", IF(ISBLANK([Case Opened Close Date]) false, true), true)))


I've been trying for hours to get this to work but haven't had any luck. Any help would be greatly appreciated.

3 Replies

Are you doing this in a calculated field or putting the code in a conditional formula for each columns?

Better to set conditional formula for each field.

For example:
In column "Request Initiated Close Date" edit the conditional formula for this field only put
=IF([Status]=='Under Review','true','false')

Do this for each column based on the required values for Status field.

@zeusPH,

I should have been more clear in my post. I'm doing it at the list validation settings because I need "Request Initiated Close Date", "Under Review Close Date", and "Case Opened Close Date" to be required fields when the user selects certain statuses. From my understanding the only way to do this is in the list validation settings.