Populating third field when you know any 2 fields

AppSheet AppSheet Q&A
,
1

hello, i’m having difficulties getting my app to give me the data i am looking for. i have a virtual column that is a yes/no labelled “fixed” (identifies a fixed blade or not). i have 4 fields: “overall length”, “blade length”, “handle length” and “closed”. i have it so when fixed is checked, the fields that show in the form are: blade, handle and overall. when it is unchecked, the form shows blade, closed and overall. ultimately what i am trying to do is to get a third number when i know any 2 of the fields for the fixed section and for the non-fixed section. i.e. if i know the overall length and the closed length of a non-fixed knife, the blade length will show the correct number based on subtracting the closed length from the overall length OR getting the overall length by adding the closed and the blade length / and for a fixed blade knife, it’ll be able to perform addition or subtraction as above with the knowledge of 2 fields . i have the following code that will get the overall number when putting numbers in the other 2 fields but that doesn’t compute the blade length if i know the overall and the closed length (for example)

ifs(or(ISBLANK([BLADE LENGTH]), ISBLANK([CLOSED]), ISBLANK([HANDLE LENGTH])), (IF([fixed blade], ([HANDLE LENGTH]+[BLADE LENGTH]), ([CLOSED]+[BLADE LENGTH])
)))

can someone please guide me to where i may find info to build this expression?

2

The way the IFS is coded, if any of the three colums are blank, you will get NO VALUES at all.
I would recommend changing the IFS to be more discerning so you CAN get values still if the RIGHT ones are present - such as:

IFS(
AND([fixed blade], ISNOTBLANK([Handle Length), ISNOTBLANK([Blade Length])),
[HANDLE LENGTH]+[BLADE LENGTH],

AND(NOT([fixed blade]), ISNOTBLANK([Closed), ISNOTBLANK([Blade Length])),
[Closed]+[BLADE LENGTH]
)

If you need a default then you can add ",TRUE, ‘expression for defualt value’ " at the end

I hope this helps!!