How To Create A Status Column In A SharePoint List



How To Create A Status Column In A SharePoint List

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.

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

LINKS TO THE JSON USED IN THE TUTORIAL:

Traffic Light Status Indicator
https://github.com/pnp/List-Formatting/tree/master/column-samples/text-ryg-status-indicator

Percentage Complete Bar Chart
https://github.com/pnp/List-Formatting/tree/master/column-samples/number-data-bar

#sharepoint #microsoft365 #tutorials

-MORE ABOUT ME-

LOOKING FOR TRAINING OR CONSULTING – CONTACT ME AT:
https://bit.ly/3OLDmbh

LETS BE FRIENDSI
🔔Instagram: https://www.instagram.com/luigiiacobellis/
🔔LinkedIn: https://www.linkedin.com/in/liacobe/
🔔Twitter: https://twitter.com/LuigiIacobellis
🔔TikTok: https://www.tiktok.com/@luigiiacobellis
🔔Reddit: https://www.reddit.com/user/OwnDirector1326
🔔Website: https://luigiiacobellis.com/
🔔Linktree: https://linktr.ee/Liacobellis

GOT A VIDEO IDEA? FILL OUT THIS FORM:
https://bit.ly/3yjEewm

SIGN UP FOR MY MONTHLY NEWSLETTER
📧 https://landing.mailerlite.com/webforms/landing/x1f0v6

PRODUCTS THAT I USE TO CREATE MY YOUTUBE VIDEOS:
⭐ Amazon StoreFront: https://www.amazon.com/shop/luiiacobellis
⭐USB Microphone – Yeti X: https://amzn.to/3QLpfVt
⭐ Web Cam -Dell UltraSharp HDR 4K: https://amzn.to/3HQ9TuO
⭐ Laptop – Dell XPS 9510: https://amzn.to/3ng1zL9
⭐ Monitor – Dell Curved 4K UHD: https://amzn.to/3OKjCoL
⭐ Mouse-Keyboard – Dell Premier Multi-Device: https://amzn.to/3OlI9kf
⭐ Lighting Kit – LimoStudio 700W Series: https://amzn.to/3u1V82q

SOFTWARE THAT I USE TO CREATE MY YOUTUBE VIDEOS & CONTENT:
⭐ Screen Recording & Editing – Camtasia: https://bit.ly/3NmF9mf
⭐ Screenshots & Photo Editing – SnagIt: https://bit.ly/3NmF9mf
⭐ YouTube Thumbnails – Canva Pro: https://bit.ly/3nj1Rkx
⭐ Content Tracking – AirTable: https://bit.ly/3dYsV3H
⭐ Email Newsletter Creation – MailerLite: https://bit.ly/3ET6SYb
⭐ Mailing List Forms – ConvertKit: https://bit.ly/3xVD5ff
⭐ Social Media Scheduling – Later: https://bit.ly/3lgeCuW
⭐ VPN – ExpressVPN – 30 Days Free: https://bit.ly/3NmGUjl
⭐ Task Tracking – Trello: https://bit.ly/3xToX69

OTHER SERVICES THAT I USE:
⭐ ETF Investing – WealthSimple – Get $10,000 Managed Free: https://bit.ly/3HQF8G5
⭐ IT Training – Global Knowledge – Save 10%: https://bit.ly/3A6l5BG
⭐ Cashback On Online Purchased – Rakuten – Get $30 Free: https://bit.ly/3OmNV59
⭐ Earn Passive Income – Survey Junkie: https://bit.ly/3OoXwZ7

Note that I may earn a small commission at no additional cost to you from purchases made using these links.

Comments are closed.