1

I'm a complete newbie to this. I'm trying to have a column show up based on two other selections in the form. So this is what I have based on one choice (after a LOT of googling):

=if([$Travel_x003f_] == 'Travel Required',  && [$Transportation] == 'Fleet Vehicle Needed', 'true', 'false')

I need to show the column based on if Travel Required is selected, AND if either 'Fleet Vehicle Needed' OR 'Rental Car' is selected. How do I do that?

1
  • What is the data/column type of both the columns? Commented Aug 5, 2023 at 5:17

1 Answer 1

0

Try using this conditional formula:

=if([$Travel_x003f_] == 'Travel Required' && ([$Transportation] == 'Fleet Vehicle Needed' || [$Transportation] == 'Rental Car') , 'true', 'false')

Make sure you are using correct internal names of your columns. Follow this article to get the internal name of your columns: How to find the Internal name of columns in SharePoint Online?

Microsoft documentation: Show or hide columns in a list or library form

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.