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”
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.