⭐🔔DOWNLOAD THE LIST OF THE BEST FREE SHAREPOINT LIST JSON FORMATTING RESOURCES INCLUDING THE JSON USED IN THIS VIDEO HERE⭐🔔: bit.ly/43qhH0X ⭐🔔SIGN UP FOR MY SHAREPOINT LIST FUNDAMENTALS ON-DEMAND COURSE.⭐🔔:academy.luigiiacobellis.com/sharepoint-list-fundamentals-pre-launch ⭐🔔GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE⭐🔔: bit.ly/3Q921sH CHECK OUT MY HOW TO USE SHAREPOINT PLAYLIST - 40+ TUTORIALS: th-cam.com/play/PLmE7KGV9-I4uibXaJ7ZqTXbbS4tukRJPh.html
awesome! I need your help! I have created a parent and child task and the issue is that I have to manually update the completion percentage bar and the progress status for both parent and child task. Is there a way for it to correlate each other so its automated?
Hi there, I'm using SharePoint Online. I do not believe that the color palette option was available in SharePoint 2019 . Hope this helps and thanks for watching.
Hi there unfortunately I won't be producing another video on this topic anytime soon. You're best bet is to post your question over on the Microsoft Tech Community techcommunity.microsoft.com/
Hello, First of all, thanks. Is it possible to customize the columns for each folder separately when we create subfolders in the Document Library after creating a folder in that folder? When I add a column, the same column is included in the parent and child folders of that folder. How can I create columns with a different number of even metadata for each folder?
Unfortunately it's not possible to do this. There are only one set of columns that apply to all list items, folders and sub folders. I hope this helps and thanks for watching
Hi London, thank you for the kind words. You would need to use automate to update values based on other values. JSON allows for visual modification of items and not real-time updates. Hope this helps!
You are welcome. I cover this very topic in my on-demand course called SharePoint List Fundamentals: academy.luigiiacobellis.com/sharepoint-list-fundamentals-pre-launch - You can use promo code "MSLOOP20" to save 20% off the start and pro plan for a limited time. I also have a basic tutorial that demonstrates how to create a SharePoint List here: th-cam.com/video/EYC_qoSha0s/w-d-xo.html
My column has different ends date. Can you please do a video on how to do different due dates in one column. Some of my task are quarterly, monthly, and annually.
Hello, my apologies for the delay in responding to your comment. I hope that you found an answer by now. I’m not sure I understand your query. Each task must reference one start and one end date. The end date can occur monthly, quarterly, or annually. It should not matter in the context of the status column. If you have multiple end date columns, then you would need to implement multiple visual status columns which is not recommended. Hope this helps and thank you for watching
Super interesting, thank you very much for all these tutorials and tips. I have watched several of your videos. For the percentages "problem", I don't believe it is ;) From my understanding, in the JSON code, the 7th line shows what is happening ("txtContent": "=(100 * @currentField) + ' %'",) the value is multiplied by 100. If you enter 5... it will give 500%. You must enter the values in decimal (or modify the code and remove the 100*). I say maybe anything :D
Hi Stephane, sorry for the delay! thank you so much for catching the JSON error! I have added this explanation to the description so others can understand it as well. I really appreciate it!
How can i make this on one File and not throughout the entire share point? I only need the columns in the accounting side of files not every single file that is in share point.
Do you know of any method to automatically update status column without using powerapps or automate? I was able to create a binary Yes/No column based on a nested IF formula, which checked values of other columns, but rather than a 2 value Yes/No, I'm trying to figure out how to switch through 8-10 different Status states based on other columns. Hope that makes sense. Thanks for your videos.
Hi there, my apologies for the delay in responding to this. The only alternative that I'm aware of would be to use IF statements. With 8-10 states though it could get messy and complex. Power Automate would likely be your best option as it is much easier to code compared to IF statements. I also have a video outlining how to do this: th-cam.com/video/bz1qSexNW9Y/w-d-xo.html - Hope this helps and thanks for watching!
@@LuiIacobellis I'm trying to do a similar thing as Simo but im very new to this, I've watched your linked video however I don't want it to be a calculation but instead I want it to be based off other columns. My list has all the inputs from a form, so for example i want the status to be 'complete' but only if the user has put in the inputs for column 1, 2 and 3 for example. Does that make sense? and if so, how would i do this?
⭐🔔DOWNLOAD THE LIST OF THE BEST FREE SHAREPOINT LIST JSON FORMATTING RESOURCES INCLUDING THE JSON USED IN THIS VIDEO HERE⭐🔔: bit.ly/43qhH0X
⭐🔔SIGN UP FOR MY SHAREPOINT LIST FUNDAMENTALS ON-DEMAND COURSE.⭐🔔:academy.luigiiacobellis.com/sharepoint-list-fundamentals-pre-launch
⭐🔔GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE⭐🔔: bit.ly/3Q921sH
CHECK OUT MY HOW TO USE SHAREPOINT PLAYLIST - 40+ TUTORIALS: th-cam.com/play/PLmE7KGV9-I4uibXaJ7ZqTXbbS4tukRJPh.html
That was awesome!!! how can you update status column in list based on change in progress bar in planner task? do you have any video on it? Thank you
The closest thing I have that covers some of your use-case is here: th-cam.com/video/-eMQuCHS6-o/w-d-xo.html
Do you have a flow of when the status changes when it’s in work in progress or deadline
awesome! I need your help! I have created a parent and child task and the issue is that I have to manually update the completion percentage bar and the progress status for both parent and child task. Is there a way for it to correlate each other so its automated?
What version of SharePoint are you using? My organization has SP 2019. I don't have the column customizations, i.e., color palette.
Hi there, I'm using SharePoint Online. I do not believe that the color palette option was available in SharePoint 2019 . Hope this helps and thanks for watching.
thank you for that tutorial but I not familiar with Jason codes so could you provide me with data bar Jason code which has bar chart regarding to %
I've shared the link to the raw code in the description of the video. It's identical to what I used in this video. Thanks!
This is great, thank you! Is there a way to change the color of the bars?
Hi there, yes within the syntax there are RGB color codes you can modify! Hope this helps!
@@LuiIacobellis could you please clarify more by example
Hi there unfortunately I won't be producing another video on this topic anytime soon. You're best bet is to post your question over on the Microsoft Tech Community techcommunity.microsoft.com/
Hello, First of all, thanks.
Is it possible to customize the columns for each folder separately when we create subfolders in the Document Library after creating a folder in that folder? When I add a column, the same column is included in the parent and child folders of that folder. How can I create columns with a different number of even metadata for each folder?
Unfortunately it's not possible to do this. There are only one set of columns that apply to all list items, folders and sub folders. I hope this helps and thanks for watching
You are a star! Could you use Jason to automate the status column based on the target date.
Hi London, thank you for the kind words. You would need to use automate to update values based on other values. JSON allows for visual modification of items and not real-time updates. Hope this helps!
Can we apply 2 different logic in the conditional formatting tab?
ok but can it be shown to the receiver ? and let the receiver choose and it just appears in Microsoft list ?
Thank you how did you get to even create a Task in SharePoint from scratch
You are welcome. I cover this very topic in my on-demand course called SharePoint List Fundamentals: academy.luigiiacobellis.com/sharepoint-list-fundamentals-pre-launch - You can use promo code "MSLOOP20" to save 20% off the start and pro plan for a limited time.
I also have a basic tutorial that demonstrates how to create a SharePoint List here: th-cam.com/video/EYC_qoSha0s/w-d-xo.html
My column has different ends date. Can you please do a video on how to do different due dates in one column. Some of my task are quarterly, monthly, and annually.
Hello, my apologies for the delay in responding to your comment. I hope that you found an answer by now. I’m not sure I understand your query. Each task must reference one start and one end date. The end date can occur monthly, quarterly, or annually. It should not matter in the context of the status column. If you have multiple end date columns, then you would need to implement multiple visual status columns which is not recommended. Hope this helps and thank you for watching
Super interesting, thank you very much for all these tutorials and tips. I have watched several of your videos.
For the percentages "problem", I don't believe it is ;) From my understanding, in the JSON code, the 7th line shows what is happening ("txtContent": "=(100 * @currentField) + ' %'",) the value is multiplied by 100. If you enter 5... it will give 500%. You must enter the values in decimal (or modify the code and remove the 100*). I say maybe anything :D
Hi Stephane, sorry for the delay! thank you so much for catching the JSON error! I have added this explanation to the description so others can understand it as well. I really appreciate it!
is there a way to hide or restrict that column from certain users?
How can i make this on one File and not throughout the entire share point? I only need the columns in the accounting side of files not every single file that is in share point.
Do you know of any method to automatically update status column without using powerapps or automate? I was able to create a binary Yes/No column based on a nested IF formula, which checked values of other columns, but rather than a 2 value Yes/No, I'm trying to figure out how to switch through 8-10 different Status states based on other columns. Hope that makes sense. Thanks for your videos.
Hi there, my apologies for the delay in responding to this. The only alternative that I'm aware of would be to use IF statements. With 8-10 states though it could get messy and complex. Power Automate would likely be your best option as it is much easier to code compared to IF statements. I also have a video outlining how to do this: th-cam.com/video/bz1qSexNW9Y/w-d-xo.html - Hope this helps and thanks for watching!
@@LuiIacobellis I'm trying to do a similar thing as Simo but im very new to this, I've watched your linked video however I don't want it to be a calculation but instead I want it to be based off other columns. My list has all the inputs from a form, so for example i want the status to be 'complete' but only if the user has put in the inputs for column 1, 2 and 3 for example. Does that make sense? and if so, how would i do this?