If false use user input expression help

[Shock]

Hello,

I have an initial question of : Is houskeeping relevant to your inspection?  yes/no

If True, the next set of questions appear each with an enum of Pass, fail, N/A, Not observed.    - This is my show if

Next step was trying to autofill  - this a am using in the app formula for the related question(s)

if [houskeeping relevant] is false, it is set to return N/A  Automatically for all related questions. - This works fine.

if [houskeeping relevant] is True, I would like the original enum of Pass, fail, N/A, Not observed to appear. 

This is failing to happen. What appears is  "pass" and it is uneditable.

How do i write this to say if true , Show the original question

an example of how i have tried to write it using one relevant column:

IF([Housekeeping_Relevant] = False,"N/A",[Heating Equipment])

[dbaum · Accepted solution]

I'm not confident that I follow what you're trying to accomplish. Based on my interpretation, the following approach might work for what you need.

In each column:

• Editable property: [Housekeeping relevant]
• Initial value property: IFS(NOT({Housekeeping relevant]), "N/A")
• (Optional) Show property: [Housekeeping relevant]

[Shock]

Initial value of IFS(NOT([Housekeeping_relevant]), "N/A") worked.

When i selected yes the next question appeared where i could make my selection, when no was selected nothing appeared.  When i saved and checked the sheet, it DID update an N/A for that field.

It didn't show while filling out my form because it was following my show if parameters of dont show the question at all if [Housekeeping_relevant] was false (Duh)

Thank you

[SkrOYC]

Make an IFS() where you cover both situations.

IFS(
 NOT([hou....]), "N/A",
 [hou....], ""
)

[Shock]

So i attempted this for a situation a little bit different. I must be doing something wrong. 

Question 1 [Passing]-  Mark all question as passing?  yes or no  

Questions 2 -5  - i wrote out the scenarios for passing if true, blank and false.  

if true = "pass"

If false , use the original question (this i am probably doing wrong)

Results - Questions 2 -5 do not appear.

Question 1 [passing] is set to true , questions 2-5 appear with "pass" as the selection- good

Question 1 [passing] is set to False , questions 2-5 do not appear - Why?

Question 2-5 are enum based with answers pass, fail, N/A and not Observed.

I would like to do this with a formula and not an action. 

[dbaum]

---

@Shock wrote:

Question 1 [passing] is set to False , questions 2-5 do not appear - Why?

---

If for questions 2-5 the Show or probably even Editable properties are set to the value of Question 1 [Passing] or the app formula has an expression, then they probably won't appear in the form. As long as Show isn't false, they can appear in non-editable views.

[Shock]

I wanted to come back to this and share my experience. Different situation, similar results.
I have an initial Value of
IF([FPS_Present_Serviced] = True,"",
IF([FPS_Present_Serviced] = False,"N/A",""))

This Works Fine. True, opens up a list of enum choices and false saves the N/A.

Now, If I select true and select N/A , I have data validity error saying i cannot do that. This is also good.
I also Have a validity error set to say If a select False and selection <> N/A , Then false.
Situation:
If I select True and select a column choice other than N/A (which is fine), and then decide i change my mind to [FPS_Present_Serviced] = False but i do not clear the choice i selected, it keeps the choice even though my selection is false.
No error is generated.

Question:
If i Select a choice, then change my mind to say [FPS_Present_Serviced] = False, and forget to change my choice to N/A,how do i set the value to clear or reset to default N/A?

Additioanlly,

When that situation is saved the display within the details is correct, FPS = No and nothing is shown for my messed up choice However,  in google sheets, my selection is shown