SharePoint list column validation - if status is a certain value, require a date in another column

[Annette1101]

I have an Asset SharePoint list that has a status column. The column values are Active, Sold, Disposed. If the status is Sold or Disposed, I want the date column "Out of Service" to be required.

I tried entering this into the Validation Setting, but I keep getting the "Sorry., something went wrong.." message.

=IF(AND(OR([Status]="Sold",[Status]="Disposed"),ISBLANK([OutOfService]),TRUE,TRUE),FALSE)

Obviously, I have the statement incorrect. Any help would be greatly appreciated!!

[#2]

Hi @Annette1101 - To have a column be conditionally required, you'll need to add a custom form or canvas app to the list. You can check out:

http://powerappsguide.com/blog/post/forms-how-to-conditionally-make-form-fields-mandatory

and

https://www.bing.com/videos/search?q=power+apps+conditionally+require+fields&qpvt=power+apps+conditi...

Hope that helps!

[#3 · Accepted solution]

@Annette1101 Use list validation formula like this: 

=IF(OR([Status]="Sold",[Status]="Disposed"),NOT(ISBLANK([OutOfService])),TRUE)

You have to use above formula in list validation settings and not in column validation settings.

Similar threads: 

1. How to have validation for SharePoint list column? 
2. SharePoint List validation formula if then syntax 

Note:

1. Sometimes comma( , ) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon( ; ) instead of comma( , ).
2. Use correct display name (not internal name) of your SharePoint columns in above formula.
3. Wrap column names inside [] if your column name has space in it. For example: [My Column Name].

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

[#4]

This was spot on!! Also, I was using the internal name instead of the display name. Thank you so much for the extra notes and links to similar threads!

[#5]

Hey @ganeshsanap,

I've followed these steps in order to make one of my SharePoint lists columns mandatory if the value "Yes" is entered in another using this formula "=IF([FFE_x002f_ICAT_x0020_Impact]="Yes", NOT(ISBLANK([FFE_x002f_ICAT_x0020_MRP_x0020_Notified])), TRUE)".

However, I keep getting the following error: "The formula cannot refer to another column. Check the formula for spelling mistakes or update the formula to reference only this column."

Any help with this would be greatly appreciated 🙂

[#6]

@mrjarrar 

You are using internal name of list columns in formula. Use correct display name (not internal name) of your SharePoint columns in above formula.

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.