I have a share point form which has 3 textbox fields (datatype=Numeric) as

  • "Wellbeing leave balance" which is by default 21.
  • Second field is "Remaining balance" which is picks up the leave balance once the leave is applied.
  • 3rd one is "Remaining balance will be" field. I want to use a calculated value which will work like lets say IF "Remaining balance" isblank then populate the value of "Remaining balance will be" field else populate value of "remaining balance".

How can I achieve this? any help would be much appreciated

enter image description here

1 Answer 1


Try this

=IF(ISBLANK([Remaining balance]), [Remaining balance will be], [Remaining balance])


It will check if the [Remaining balance] field value is empty, show the value of the [Remaining balance will be] else use [Remaining balance] field value.


I didn't see the InfoPath tag :)

In InfoPath, it's easy to add a Rule Condition as the following:

  • Select your field,
  • Add rule as shown below

enter image description here

  • Select the field as [Remaining balance] and select the value as [Remaining balance will be] from Fx button and insert field.
  • EL-Qassas Im getting error. doesnt allow me
    – Biswa
    Nov 30, 2018 at 10:56
  • Which error did you get? Are you sure you have added the fields name in a correct manner Nov 30, 2018 at 10:57
  • i have added the screenshot of my error on my question.
    – Biswa
    Nov 30, 2018 at 11:01
  • can you please answer me brother, im watiing
    – Biswa
    Nov 30, 2018 at 11:18
  • @Biswa Check the updated answer, don't hesitate if you need further clarification! Dec 4, 2018 at 9:55

Your Answer

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

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