Reveal on either selection and on another

Question

Hi.

There are three columns: Brief Type, Estimating Requirement and Production Quote Date Required within a SharePoint list form.
When a user selects either 'New' or 'Revision' under Brief Type and 'Yes, submit' is selected under the Estimating Requirement, the column Production Quote Date Required must appear.

This code has been used but does not do what is required: =if([$CUSTOMERNAME]=='New'||[$CUSTOMERNAME]=='Revision'&&[$Requirement_x0020__x0028_6_x0029]=='Yes, submit','true','false')

Please can you help me with the correct code?

Thank-you.

Answer 1

@Lorne Andersen

Please use following formula in the condition.

=if([$EstimatingRequirement]=='Yes, submit'&&[$BriefType]=='New'||[$EstimatingRequirement]=='Yes, submit'&&[$BriefType]=='Revision', true, false)

---

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.