How To Create A Status Column In A SharePoint List

This tutorial will demonstrate how to create a status column in a SharePoint List. Specifically, it will demonstrate how to create a status column in SharePoint Online list. A SharePoint status column allows you to record the state of an item or record through its lifecycle. SharePoint status indicators can be used to quickly display what action ought to be taken with an item or record. This tutorial will demonstrate how to create visual SharePoint task list status indicator. This tutorial will also demonstrate how to add conditional formatting to your SharePoint status tracker to display different color backgrounds per state and to add icons to your states. This tutorial will answer the following questions: How do I add a status bar in SharePoint, How do I add a status column in SharePoint, How do I create a status list in SharePoint.
⭐🔔DOWNLOAD THE LIST OF THE BEST FREE SHAREPOINT LIST JSON FORMATTING RESOURCES INCLUDING THE JSON USED IN THIS VIDEO HERE⭐🔔: bit.ly/43qhH0X
⭐🔔COMING SOON: SHAREPOINT LIST FUNDAMENTALS ON-DEMAND COURSE. JOIN THE WAITLIST TO GET EARLY ACCESS AND EARLY BIRD PRICING⭐🔔: bit.ly/3Ti2aNq
⭐🔔GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE⭐🔔: bit.ly/3Q921sH
NOTE:
The error referenced in the video is not an error but rather how the JSON syntax is written. The 7th line features the text - ("txtContent": "=(100 * @currentField) + ' %'",) the value is multiplied by 100. If you enter 5... it will give 500%. You must enter the values in decimal for this to function correctly using the code as is.
Timeline:
0:00 - Start
1:12 - How to create a status column in a SharePoint List
4:16 - How to format status columns in a SharePoint List
8:14 - How to add a traffic light SharePoint status indicator
10:50 - How to add a bar chart to a SharePoint List column
#sharepoint #microsoft365 #tutorials
MORE ABOUT ME
LOOKING FOR TRAINING OR CONSULTING - CONTACT ME AT:
bit.ly/3OLDmbh
LETS BE FRIENDSI
🔔Instagram: / luigiiacobellis
🔔LinkedIn: / liacobe
🔔Twitter: / luigiiacobellis
🔔TikTok: / luigiiacobellis
🔔Reddit: / owndirector1326
🔔Website: luigiiacobellis.com/
🔔Linktree: linktr.ee/Liacobellis
GOT A VIDEO IDEA? FILL OUT THIS FORM:
bit.ly/3yjEewm
SIGN UP FOR MY MONTHLY NEWSLETTER
📧 landing.mailerlite.com/webfor...
PRODUCTS THAT I USE TO CREATE MY KZbin VIDEOS:
⭐ Amazon StoreFront: www.amazon.com/shop/luiiacobe...
⭐USB Microphone - Yeti X: amzn.to/3QLpfVt
⭐ Web Cam -Dell UltraSharp HDR 4K: amzn.to/3HQ9TuO
⭐ Laptop - Dell XPS 9510: amzn.to/3ng1zL9
⭐ Monitor - Dell Curved 4K UHD: amzn.to/3OKjCoL
⭐ Mouse-Keyboard - Dell Premier Multi-Device: amzn.to/3OlI9kf
⭐ Lighting Kit - LimoStudio 700W Series: amzn.to/3u1V82q
SOFTWARE THAT I USE TO CREATE MY KZbin VIDEOS & CONTENT:
⭐ Screen Recording & Editing - Camtasia: bit.ly/3NmF9mf
⭐ Screenshots & Photo Editing - SnagIt: bit.ly/3NmF9mf
⭐ KZbin Thumbnails - Canva Pro: bit.ly/3nj1Rkx
⭐ Content Tracking - AirTable: bit.ly/3dYsV3H
⭐ Email Newsletter Creation - MailerLite: bit.ly/3ET6SYb
⭐ Mailing List Forms - ConvertKit: bit.ly/3xVD5ff
⭐ Social Media Scheduling - Later: bit.ly/3lgeCuW
⭐ VPN - ExpressVPN - 30 Days Free: bit.ly/3NmGUjl
⭐ Task Tracking - Trello: bit.ly/3xToX69
OTHER SERVICES THAT I USE:
⭐ ETF Investing - WealthSimple - Get $10,000 Managed Free: bit.ly/3HQF8G5
⭐ IT Training - Global Knowledge - Save 10%: bit.ly/3A6l5BG
⭐ Cashback On Online Purchased - Rakuten - Get $30 Free: bit.ly/3OmNV59
⭐ Earn Passive Income - Survey Junkie: bit.ly/3OoXwZ7
Note that I may earn a small commission at no additional cost to you from purchases made using these links.

[@LuiIacobellis]

⭐🔔DOWNLOAD THE LIST OF THE BEST FREE SHAREPOINT LIST JSON FORMATTING RESOURCES INCLUDING THE JSON USED IN THIS VIDEO HERE⭐🔔: bit.ly/43qhH0X ⭐🔔COMING SOON: SHAREPOINT LIST FUNDAMENTALS ON-DEMAND COURSE. JOIN THE WAITLIST TO GET EARLY ACCESS AND EARLY BIRD PRICING⭐🔔: bit.ly/3Ti2aNq ⭐🔔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: kzbin.info/aero/PLmE7KGV9-I4uibXaJ7ZqTXbbS4tukRJPh

[@dominicatuahene7303]

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

[@LuiIacobellis]

The closest thing I have that covers some of your use-case is here: kzbin.info/www/bejne/Y5awgqh5fbhpY9E

[@iyanu]

Do you have a flow of when the status changes when it’s in work in progress or deadline

[@sanjayrawat9768]

Can we apply 2 different logic in the conditional formatting tab?

[@KhadeejaAhmed-bp8gb]

ok but can it be shown to the receiver ? and let the receiver choose and it just appears in Microsoft list ?

[@va3bells]

What version of SharePoint are you using? My organization has SP 2019. I don't have the column customizations, i.e., color palette.

[@LuiIacobellis]

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.

[@cem313]

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?

[@LuiIacobellis]

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

[@londonengland2309]

You are a star! Could you use Jason to automate the status column based on the target date.

[@LuiIacobellis]

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!

[@stephanedenis5394]

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

[@LuiIacobellis]

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!

[@eslamfahmy87]

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 %

[@LuiIacobellis]

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!

[@dianekmk]

This is great, thank you! Is there a way to change the color of the bars?

[@LuiIacobellis]

Hi there, yes within the syntax there are RGB color codes you can modify! Hope this helps!

[@eslamfahmy87]

@@LuiIacobellis could you please clarify more by example

[@LuiIacobellis]

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/

[@nasenelijah]

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.

[@romeredd6083]

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.

[@LuiIacobellis]

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

[@ramses_is_numba_one]

is there a way to hide or restrict that column from certain users?

[@Simo-un2zu]

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.

[@LuiIacobellis]

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: kzbin.info/www/bejne/mKuUooabrbOKb7s - Hope this helps and thanks for watching!

[@Tom70898]

@@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?