IFS Expression Help

[Sarah_Keown]

Hi, I’m working on an ordering app that requires numerous status updates through the process, such as the following:

• If an Order No is equal to zero it is Requested

• If an Order No IS NOT equal to zero is it Ordered

• If the Qty Ordered is equivalent to the Qty Received it is Received in Full

• If the Qty Ordered IS NOT equivalent to the Qty Received it is Order Short

This logic makes sense in my head and when reading the expression I have tried everything appears correct; except when I change the data and there is no status change. The image below is the current expression I am applying, if there are any changes to make this work all help is appreciated. Thanks!

[Heino_Matthee]

change “Requested” to [status] = “Requested” and remove the true.

IFS work like this IFS(check condition1, return statement1, check condition2, return statement2, etc) so you dont need all the seperate IFS.

if condition 1 is false it doesnt use return statement1 and so forth.

help.appsheet.com

IFS()

First-match conditional evaluation

[Sarah_Keown]

Thank you, is this the syntax you are referring to? I applied this and in return got no value for each orders status so I am not sure what has gone wrong.

[Heino_Matthee]

your request status is set to (Yes/No) type. Set it to a text type and it should work. Also you don’t need another comma after the last statement.

[Sarah_Keown]

I think a consequence of this syntax is making the values either “true” or “false”.

[Sarah_Keown]

It is set back to Text Type also, thank you

[Heino_Matthee]

did it set the status to true after you set the column type to text?

[Sarah_Keown]

Yes it did

[Sarah_Keown]

That was amended, but the request status is still not updating as the data changes. This is a request that has been received in full but the status does not update from “Ordered”.

[Heino_Matthee · Accepted solution]

The IFS statement checks everything in order and selects the first condition that is satisfied, maybe rearrange them so the one that should happen last is checked first. IE the recieved in full condition.

[Sarah_Keown]

Thank you! That seemed to do the trick, I had no idea about the order of IFS statements I will keep this in mind in future