IFS retuns "False" instead of value

I am tying to use the IFS function to populate another field based on the value of another field entered by the user.  the goal is to have a short text summary concatenated from five data entry fields.

the data entry field [DateEntry1....5) is numeric, the IFS field [TxtData1...5] is text and combines the [DataEnty1] with a descriptor.  the IFS field [TxtData1] is then combined in the summary field [Summary].

The IFS statement for [TxtData1] is:

IFS([DateEntry1]> 0, "Frag.= "&[DateEntry1], [DateEntry1]= 0, "")

so ideally I get either "Frag.=n" in [TxtData1] or [TxtData1] will be blank.

however, I am getting "false" in [TxtData1] when [DataEntry1] = 0

I have tried using null instead of "" but get "null"

 

 

0 3 50
3 REPLIES 3

What about if you just use IFS([DateEntry1]>0, "Frag.= "&[DateEntry1])? Then it should not do anything if if the evaluation is not true.

It seems that your IFS() statement only has two conditions:
Either > 0, or 0.   

I would recommend to just try doing a simple IF().

IF( [DateEntry1]>0,
  "Frag.= "&[DateEntry1],
  ""
)

I wonder also if the value [DateEntry1] is initialized to 0? If you have not you could consider setting "Initial Value".

You could also try to see if this works better:
IFS([DateEntry1]> 0, "Frag.= "&[DateEntry1], ISBLANK[DateEntry1], "")

or even:

IFS([DateEntry1]> 0, "Frag.= "&[DateEntry1], [DateEntry1]= 0, "", true, "")

Or ofcourse the replies from the other responders also may do the trick.

Top Labels in this Space