0

I need your help to fix my issue, basically what I want is when users select B from choice filed, the next column become mandatory.

Below formula doesn't work:

=IF([A]="B", [TEST] = " "), TRUE, FALSE), TRUE)

enter image description here

2 Answers 2

1

Use this formula:

=IF([A] = "B", IF([TEST] = "", FALSE, TRUE), TRUE)

OR

=IF([A] = "B", IF(ISBLANK([TEST]), FALSE, TRUE), TRUE)

Reference:

  1. Calculated Field Formulas
  2. IS functions - ISBLANK

Update from Comments:

To make multiple columns mandatory, you can use OR function in 2nd condition like:

=IF([A] = "B", IF(OR([TEST] = "", [TEST1] = ""), FALSE, TRUE), TRUE)

OR

=IF([A] = "B", IF(OR(ISBLANK([TEST]), ISBLANK([TEST1])), FALSE, TRUE), TRUE)
4
  • Thanks for your help Ganesh. It worked. Also If I want to have another column for instance TEST1 then how it works. for instance if you select B, the column TEST and TEST1 become mandatory
    – Harris
    Commented Apr 9, 2021 at 1:03
  • Check updated answer for making multiple columns mandatory Commented Apr 9, 2021 at 3:08
  • Hi @Harris, does this answers your question? If yes, please Upvote(^) and accept as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily. It also removes this question from "Unanswered questions" list. Commented May 14, 2021 at 8:54
  • When I try and use this formula for a single column, my custom error message does not display, I just get this error at the very top of the form - Error: The server was unable to save the form at this time. Please try again. Additionally, the form pops open a date picker for a required date field which already had a date specified. I have posted a question about this behaviour here: sharepoint.stackexchange.com/q/307172 Commented Apr 5, 2023 at 23:11
0

Use this formula:

=IF(ColumnA="B",IF(Text="******",TRUE,FALSE),TRUE)

enter image description here

enter image description here

2
  • OP wants to make 2nd field mandatory and not have fixed value in 2nd field. Commented Apr 8, 2021 at 4:50
  • 1
    Hello,Ganesh Sanap. Thank you for your guidance instructions. Have a nice day! Commented Apr 27, 2021 at 7:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.