The formula worked great with my choice column on the form. However, I had to change that column to a look up column.. Does the formula change slightly? I still need the show/hide function. Any suggestions please?!
Worked great...sort of. Hide and show work fine. However, if Field1 condition has Field2 to display, once you tab out of Field1 it auto tabs to Field3 AND displays Field2. Now the User has to back-tab to complete the data in Field2. How do you show Field2 AND not auto-skip to the Field3?
Wonderful video. If my Sharepoint list has sections formatted in the body. And I want to hide all fields in that section. How would I go about hiding the title of that section also? Thanks!
Thanks for the video! As far as you know, is there any way to hide specific fields to people who are granted the "view only" option (permission granted via power automate flow)? I have a SP List regarding facility management tickets and I would like to hide some fields to requester (prices, agreements) but still show some others (status, description, etc..)..
Is it possible to make a field mandatory if a condition is met? So for example, if VIP = true, make visible VIP Reason, AND also make VIP Reason mandatory.
Hi there, to the best of my knowledge it's not possible to do this using conditional formulas on the SP list form. You can do this with list validation and I have a tutorial that demonstrates how to do this here: th-cam.com/video/K9Dg2sDKGuA/w-d-xo.html
Is it possible to show a field if more than one option is selected in another field? For instance, we want to show a field (vendor number) if one of two options under our request type field is selected.
How can you edit or remove conditional formatting? I was testing a formula but it's not working. Can't figure out how to edit or remove it since the column has been removed from my edit column list.
Hi Spencer, the field should show up in the Edit column list even though its hidden. I've noticed that SharePoint is a bit buggy at times where it won't display the column in the edit column list however. How I've overcome this is to click into the new item form, and then click into the edit form and configure layout. Click save and close it and the column should reappear. Hope this helps and thanks for watching!
Hi Aji, yes you can use nested IF statements as well. See this article for more info: learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide - Hope this helps and thanks for watching!
Hello Lui, I am looking for a query to show fields based on a multiple selection, for example I have an options field, where I select A, it shows me the fields, but also that when I select B, it also shows them. I have A,B,C,D in the options and I only want it to show when I select A or B
Hi there unfortunately I can't assist with individual requests via chat. Id suggest posting your specific use case over on the Microsoft Tech Community or alternatively try using an generative AI app such as Chat gpt or Copilot.
Hi Lui, thanks for this video. It's something I've long wanted to achieve. However, the edit form icon is missing from all of my lists' New forms. Any idea what's wrong?
You're very welcome. I've not experienced this issue but I did come across this post on StackExchange: sharepoint.stackexchange.com/questions/297841/edit-form-option-is-missing - Maybe this might assist you.
Yes. You can use nested IF statements. Simply copy the IF statement and paste it in place of either the 'true' or 'false' term. Example: IF([$Status]=='Open', true, IF([$City]=='New York', true, false)) In plain language, this statement says: "If status is not open, do not show this field ... unless the city is New York."
Hi Lui, for some reason my formula is not working regardless of various field types I tried. I have a list with many columns and settings. When I tried a new list with a few columns only it worked. Is there anything I potentially screwed up in the large list which blocks conditions to work? Thx
Hi there, I have also experienced similar issues. I would recommend clearing your Browser history, cookies and cache memory and then trying again. Sometimes the browser stores info that will cause SharePoint to throw errors. Hope this helps and thanks for watching!
I need the "blank" rows to be hid in the default view. When I sort my date column ascending, all the blanks come to the top. So I have to keep scrolling till I reach the first item. I'd like this to be the default view.
Hi Tessica Cornelius , I would suggest posting this question over on the Microsoft Tech Community as you will likely be able to get a fast and more detailed response. You can access it at this link: techcommunity.microsoft.com/ - Hope this helps and thanks for watching!
hi luigi i've tried the conditional formula however it's not working and this issue may caused because i've italian version of sherepoint...any ideas? thank you in advance and sorry for my bad english
Hi there, to the best of my knowledge it shouldn't matter what language your SharePoint environment is configured too when working with formulas. Hope this helps
Nice video. I tried this, but with a != operator and == and I keep getting an error saying "enter a valid condition". I tried it with several columns and no luck. I tried it in an incognito window as well and nothing. Not sure where i went wrong
You can use the "! =" however there are some restrictions on what columns can be used when hiding and showing fields. Here is an article which some info on this point. I'd also suggest posting your comment over on the Microsoft Tech Community with the formulas as someone can help correct the error Hope this helps and thanks for watching sharepoint.stackexchange.com/questions/304962/not-equal-to-for-show-or-hide-columns-in-a-list-or-library-form
This did not work for me. I used lower case letters and tried refreshing the site, but now the field just does not show on my new item window. Do you know if MIcrosoft changed the permissions?
To the best of my knowledge, nothing has changed as it pertains to conditionally hiding & showing fields. I would suggest posting this question over on the Microsoft Tech Community as you will likely be able to get a fast and more detailed response. You can access it at this link: techcommunity.microsoft.com/ - Hope this helps and thanks for watching!
Yes, as pointed out above, in order for this to work when your reference column has a space, you will need to remove the space in the formula. Hope this helps! Thanks for watching!
Hi Tamim, this would likely require that you build a custom form using Microsoft Power Apps. With this approach you can use more logic and conditions . Hope this helps!
🔔GO FROM SHAREPOINT LIST AMATEUR TO EXPERT IN 90 MINUTES🔔 bit.ly/3zMRRK1
CHECK OUT MY HOW TO USE SHAREPOINT PLAYLIST - 40+ TUTORIALS: th-cam.com/play/PLmE7KGV9-I4uibXaJ7ZqTXbbS4tukRJPh.html
Thank you Lui. This is very detailed!
You're very welcome Shirley and thanks for watching
The formula worked great with my choice column on the form. However, I had to change that column to a look up column.. Does the formula change slightly? I still need the show/hide function. Any suggestions please?!
Worked great...sort of. Hide and show work fine. However, if Field1 condition has Field2 to display, once you tab out of Field1 it auto tabs to Field3 AND displays Field2. Now the User has to back-tab to complete the data in Field2. How do you show Field2 AND not auto-skip to the Field3?
Wonderful video. If my Sharepoint list has sections formatted in the body. And I want to hide all fields in that section. How would I go about hiding the title of that section also?
Thanks!
Thanks for the video! As far as you know, is there any way to hide specific fields to people who are granted the "view only" option (permission granted via power automate flow)? I have a SP List regarding facility management tickets and I would like to hide some fields to requester (prices, agreements) but still show some others (status, description, etc..)..
Unfortunately you cannot hide fields based on a user's permissions. You would need to use Power apps to accomplish something like that.
GET THE FORMULAS REFERENCED IN THIS TUTORIAL:
bit.ly/46Ls1B9
Is it possible to make a field mandatory if a condition is met? So for example, if VIP = true, make visible VIP Reason, AND also make VIP Reason mandatory.
Hi there, to the best of my knowledge it's not possible to do this using conditional formulas on the SP list form. You can do this with list validation and I have a tutorial that demonstrates how to do this here: th-cam.com/video/K9Dg2sDKGuA/w-d-xo.html
Hi Lui, how about the conditional hide show must be filled up before saving the item?
Is it possible to show a field if more than one option is selected in another field? For instance, we want to show a field (vendor number) if one of two options under our request type field is selected.
Same here. Is it possible to use " IF OR"?
Yes, it is possible to use multiple conditions here.
How can you edit or remove conditional formatting? I was testing a formula but it's not working. Can't figure out how to edit or remove it since the column has been removed from my edit column list.
Hi Spencer, the field should show up in the Edit column list even though its hidden. I've noticed that SharePoint is a bit buggy at times where it won't display the column in the edit column list however. How I've overcome this is to click into the new item form, and then click into the edit form and configure layout. Click save and close it and the column should reappear. Hope this helps and thanks for watching!
And what if we want to hide a column and depending on another field show it again? Is that a limitation?
Can nested if conditions be used too?
Hi Aji, yes you can use nested IF statements as well. See this article for more info: learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide - Hope this helps and thanks for watching!
@@LuiIacobellis I am hoping to do similar - in my example it would be USA or other option...is this possible..The site leads me to believe not...
@@jillmcghee446 I'm trying to figure out the same. If they choose 2 out of 4 choices, I want to show a field.
Any alternate solution how can we reference multiple values in condition to hide or show columns.
Hi, How can i use similar formula for number column. If Late > 0, show reason for late column
Hello Lui, I am looking for a query to show fields based on a multiple selection, for example I have an options field, where I select A, it shows me the fields, but also that when I select B, it also shows them. I have A,B,C,D in the options and I only want it to show when I select A or B
Hi there unfortunately I can't assist with individual requests via chat. Id suggest posting your specific use case over on the Microsoft Tech Community or alternatively try using an generative AI app such as Chat gpt or Copilot.
Is it possible to hide/show entire section?
I was able to hide the column so it doesn`t show when clicking New, but it still appears in the grid view, how can I hide it from there too?
Hi Lui, thanks for this video. It's something I've long wanted to achieve.
However, the edit form icon is missing from all of my lists' New forms.
Any idea what's wrong?
You're very welcome. I've not experienced this issue but I did come across this post on StackExchange: sharepoint.stackexchange.com/questions/297841/edit-form-option-is-missing - Maybe this might assist you.
Hi, is there a way to enter a conditional formula based on logged in user's email to show/hide the column in the list. Thank you!
Not that I am aware of. This would be best accomplished through a custom form in Power Apps. Hope this helps!
Is it possible to combine 2 "if" formulas to displayed a field depending on the answer of 2 different fields?
Yes. You can use nested IF statements. Simply copy the IF statement and paste it in place of either the 'true' or 'false' term.
Example: IF([$Status]=='Open', true, IF([$City]=='New York', true, false))
In plain language, this statement says: "If status is not open, do not show this field ... unless the city is New York."
Thanks for the response!
Very good!
Thanks!
Thanks for the detailed video - how do you write NOT EQUAL TO in the formula?
it should be A != B
Thank you for the response!
Hi Lui, for some reason my formula is not working regardless of various field types I tried. I have a list with many columns and settings. When I tried a new list with a few columns only it worked. Is there anything I potentially screwed up in the large list which blocks conditions to work? Thx
Hi there, I have also experienced similar issues. I would recommend clearing your Browser history, cookies and cache memory and then trying again. Sometimes the browser stores info that will cause SharePoint to throw errors. Hope this helps and thanks for watching!
Did you ever get this to work? I am running into the exact same problem. I tried clearing the browser with no luck.
Is it possible to use multiple conditions here?
Yes, you can indeed use multiple conditions!
I need the "blank" rows to be hid in the default view. When I sort my date column ascending, all the blanks come to the top. So I have to keep scrolling till I reach the first item. I'd like this to be the default view.
Hi Tessica Cornelius , I would suggest posting this question over on the Microsoft Tech Community as you will likely be able to get a fast and more detailed response. You can access it at this link: techcommunity.microsoft.com/ - Hope this helps and thanks for watching!
I'm trying to make Attachments section show on condition and even though not on that exclusion list, doesn't seem to work. Any suggestions?
I've never tried to conditionally hide-show an attachment field. I'd suggest posting this over on the Microsoft Tech Community.
I couldnt get this to work for the life of me. The form just doesnt do anything. Is there a way to book a consult call with you to troubleshoot?
hi luigi i've tried the conditional formula however it's not working and this issue may caused because i've italian version of sherepoint...any ideas? thank you in advance and sorry for my bad english
Hi there, to the best of my knowledge it shouldn't matter what language your SharePoint environment is configured too when working with formulas. Hope this helps
is it possible to add more than one values to check
Yes, you can incorporate multiple checks.
Nice video. I tried this, but with a != operator and == and I keep getting an error saying "enter a valid condition". I tried it with several columns and no luck. I tried it in an incognito window as well and nothing. Not sure where i went wrong
You can use the "! =" however there are some restrictions on what columns can be used when hiding and showing fields. Here is an article which some info on this point. I'd also suggest posting your comment over on the Microsoft Tech Community with the formulas as someone can help correct the error Hope this helps and thanks for watching sharepoint.stackexchange.com/questions/304962/not-equal-to-for-show-or-hide-columns-in-a-list-or-library-form
is it possible to check if value is blank another field to be hide?
You will need to use list validation for this: th-cam.com/video/K9Dg2sDKGuA/w-d-xo.html
This did not work for me. I used lower case letters and tried refreshing the site, but now the field just does not show on my new item window. Do you know if MIcrosoft changed the permissions?
To the best of my knowledge, nothing has changed as it pertains to conditionally hiding & showing fields. I would suggest posting this question over on the Microsoft Tech Community as you will likely be able to get a fast and more detailed response. You can access it at this link: techcommunity.microsoft.com/ - Hope this helps and thanks for watching!
is there a way to use that if the name of the formula contains spaces?
Same question
I just removed the spaces in the formula and it worked for me
Yes, as pointed out above, in order for this to work when your reference column has a space, you will need to remove the space in the formula. Hope this helps! Thanks for watching!
Hellow, I am using the same formula, but after applying it just gets hidden and not showing even if I choose the specified option
Unfortunately I can't assist with troubleshoot individual issues via chat. Thanks
I get the same issue
How do I show or hide a column in the form depending on who is the user? I have four levels of approval.
Hi Tamim, this would likely require that you build a custom form using Microsoft Power Apps. With this approach you can use more logic and conditions . Hope this helps!
Not working for me. Keeps showing "Enter a valid condition". Is this a bug?
how do i hide a column if it's completely empty and show it if not?
You will need to use list validation to do this: th-cam.com/video/K9Dg2sDKGuA/w-d-xo.html
What could be wrong with this one, it will say that to enter a valid condition
=if([$What went well behaviors] == 'Direct', 'true', 'false')
Unfortunately I cannot troubleshoot formulas, I'd suggest posting this on the Microsoft Tech Community