SOLVED

Why isn't my Validation Settings formula working?

Copper Contributor

Hi,

 

If users choose the status "Meeting Scheduled" for my 'Feedback Response' column but then proceed to leave another column titled 'Date Meeting Scheduled' blank, I want a message to pop up for them.

 

I tried writing a formula in the Validation Settings but it's not working. What did I do wrong?

 

=IF([Feedback Response]="Meeting Scheduled",IF(ISBLANK([Date Meeting Scheduled]),FALSE,TRUE),TRUE)

3 Replies

@me1995_ Your formula syntax looks fine to me.

 

  1. Do you get any syntax error message while saving the formula or formula is not working as expected after saving?
  2. What is the column type of "Feedback Response" and "Date Meeting Scheduled" columns?

Try using this formula once in List settingsValidation settings page: 

 

=IF([Feedback Response]="Meeting Scheduled",NOT(ISBLANK([Date Meeting Scheduled])),TRUE)

 

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 of your SharePoint columns in above formula (case sensitive).
  3. Use correct values (like "Meeting Scheduled") in comparison in formula (case sensitive).
  4. 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.

@ganeshsanap thanks for the input. 1 - I'm not getting any error messages, it's simply not applying when I go try to test it. 2- Column type for "Feedback Response" is multiple choice from a series of text and Column Type for "Date Meeting Scheduled" is Date and Time.

 

That formula you provided unfortunately did not work either. Do you think it may be an issue with my SharePoint as a whole? For example, I have a list on my navigation that I've been trying to remove from my Navigation sidebar and have it checked to "No" to not appear in navigation, but no matter how many times I try to set it to "No" it continues to appear in my navigation.

 

Is there possibly an underlying issue here with my SharePoint? Do you know who I could reach out to for this or any troubleshooting I myself could do?

best response confirmed by me1995_ (Copper Contributor)
Solution

@me1995_ 

 

Unfortulately, SharePoint validation (or calculated column) formulas don't support the choice columns with multiple selection allowed.

 

So, you cannot achieve it using the list validation settings.

 

If you are using SharePoint Online list, you can achieve it by customizing list forms using Power Apps and using Power Apps formulas to apply validation before submitting the form. Check: Customize a Microsoft Lists or SharePoint form by using Power Apps 

 

Also, for any SharePoint service related bugs/issues you can reach out to Microsoft support directly by following: Get M365 support - online support 


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.

1 best response

Accepted Solutions
best response confirmed by me1995_ (Copper Contributor)
Solution

@me1995_ 

 

Unfortulately, SharePoint validation (or calculated column) formulas don't support the choice columns with multiple selection allowed.

 

So, you cannot achieve it using the list validation settings.

 

If you are using SharePoint Online list, you can achieve it by customizing list forms using Power Apps and using Power Apps formulas to apply validation before submitting the form. Check: Customize a Microsoft Lists or SharePoint form by using Power Apps 

 

Also, for any SharePoint service related bugs/issues you can reach out to Microsoft support directly by following: Get M365 support - online support 


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.

View solution in original post