Reveal after selections from two columns

Lorne Andersen 61

The column Fault Description appears when the "Machine Down" is selected under the Maintenance Type column (Pic1).

If the user instead chose either "Break and Fix" or "Preventative" and any selection under the column Estimated Time Duration (Pic2), then the Fault Description column must appear.

I have used this formula unsuccessfully: =if([$Estimated_x0020_Time_x0020_Durat]==''&&[$Maintenance_x0020_Type]=='Machine Down'||[$Maintenance_x0020_Type]=='Break and Fix'||[$Maintenance_x0020_Type]=='Preventative', true, false)

Xyza Xue_MSFT 27,501 Reputation points Microsoft Vendor

2022-10-17T02:35:22.837+00:00
Hi @Lorne Andersen ，
I would like to confirm with you that the conditions for The column Fault Description to appear are the following:

"Machine Down" is selected under the Maintenance Type column

"Break and Fix" is selected under the Maintenance Type column

"Preventative" is selected under the Maintenance Type column
4.any selection under the column Estimated Time Duration (eg 1 to 2 hrs, etc.)
If any of the above 4 situations occurs, The column Fault Description will appear, right?
Xyza Xue_MSFT 27,501 Reputation points Microsoft Vendor

2022-10-18T06:36:33.22+00:00

Hi @Lorne Andersen ，
Please confirm your needs with me so that I can provide you with an answer faster, and if I misunderstand your needs, please feel free to let me know.
Lorne Andersen 61 Reputation points

2022-10-18T07:15:40.317+00:00

Hi Haoyan. I did respond yesterday but I see it did not go through. Sorry about that. Thank you for following up.

Is it possible to have a Teams Meeting so I can show you what I mean?
Xyza Xue_MSFT 27,501 Reputation points Microsoft Vendor

2022-10-18T07:23:56.843+00:00

Sorry, we are not allowed to hold a Teams Meeting, maybe you can describe your needs to me clearly with an example.
Lorne Andersen 61 Reputation points

2022-10-18T15:25:50.813+00:00
Please look at screenshot 1 & 2.

The column "Maintenance" will either have "Break and Fix" or "Preventative" as a selection from a drop down menu.

The column "Estimated Time Duration" too will have any selection from a drop down menu.

The column "Fault Description" is a free text field that must be filled in.

The column "Date & Time Agreed With Customer" must only appear when:

Example 1:
Maintenance: Break and Fix
Estimated Time Duration: any item selected
Fault Description: any text inputted
Date & Time Agreed With Customer: Appears once the above has been done.

Or Example 2:
Maintenance: Preventative
Estimated Time Duration: any item selected
Fault Description: any text inputted
Date & Time Agreed With Customer: Appears once the above has been done.

Accepted answer

Xyza Xue_MSFT 27,501 Reputation points Microsoft Vendor

2022-10-19T02:48:05.19+00:00
Hi @Lorne Andersen ，
Thanks for your detailed description, I finally achieved what you wanted.
The effect achieved is as follows:

I have used this formula successfully:

=(if([$MaintenanceType]=='Break and Fix'||[$MaintenanceType]=='Preventative',true,false))&&if([$FaultDescription]=='',false,true)

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Reveal after selections from two columns

0 additional answers

Your answer