I have the below formula that works good in SharePoint form but not in InfoPath form.

=if(AND(field1="", field2=""),"Not-Required","Required")

The above formula is added to a calculated column in SharePoint which displays the results post submission of form.

However I need equivalent formula to input in InfoPath form calculated field so that I can display the value even before the form is submitted to list.

please confirm if we have equivalent Xpath formula for the above.

  • Did you notice the spelling of "Feidl1"?
    – user43832
    Commented Aug 8, 2021 at 20:47
  • i'm sorry but the spelling in infopath form is correct and i guess there is no IF statement can be entered to a calculated field. I want an equivalent formula for the below to use in Xpath expression. =if(AND( Field1="", field2=""),"Not-Required","Required")
    – Karthik H
    Commented Aug 9, 2021 at 5:45


Your Answer

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