SharePoint List Colors – Office 365 SharePoint 2013/2016

Color Status Indicator

Verified 2016

 http://christine-payton.com/color-coding-a-sharepoint-list/

Grade Example

Create Numerical Column named Score

Create Calculated Column named Grade

=IF([Score]>89,"A",IF([Score]>79,"B", IF([Score]>69,"C",IF([Score]>59,"D","F"))))

Create Calculated Column named Color … hidden in final view

=IF([Score]>89,"Green",IF([Score]>79,"Green", IF([Score]>69,"Yellow",IF([Score]>59,"Red","Red"))))

Create Calculated Column named Status … note must be numeric

=CONCATENATE("<div style=",CHAR(34),"height:20px;width:20px;border-radius:3px;background-color:",[Color],CHAR(34),">&nbsp;</div>")

UPDATE: border-radius:100% changes it to circle

More

My 'Title' field returns the following results:

ie: Gold.png

I want to remove '.png' and just leave the word 'Gold'

=REPLACE([Title],SEARCH(".png",[Title]),"4","")

References

https://blog.splibrarian.com/2012/06/06/using-calculated-columns-to-add-color-coding-to-your-sharepoint-lists/

https://support.office.com/en-us/article/IF-function-7025be14-5665-43d0-af20-8293d1fe9d3a

https://www.w3schools.com/tags/ref_colornames.asp

Calender

https://www.premierpointsolutions.com/training/help-and-how-to-articles/color-code-events-on-a-sharepoint-calendar/

https://www.degdigital.com/insights/four-easy-steps-to-customized-color-code-calendars-in-sharepoint/

http://eimagine.com/sharepoint-color-coding-your-calendar-by-category-tutorial/

Calendar - Office 365

https://stoneridgesoftware.com/creating-a-color-coded-calendar-in-sharepoint-online/

SharePoint Branding

2019

Branding guidance for SharePoint

Branding guidance for SharePoint Online portals
https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/portal-branding

How to brand SharePoint and Office 365 Out of the Box
https://sharepointmaven.com/how-to-brand-sharepoint-and-office-365-out-of-the-box/

Branding for SharePoint sites in Office 365https://www.abelsolutions.com/branding-sharepoint-sites-office-365/

SharePoint Site Theming
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-theming/sharepoint-site-theming-overview

Theme Generator
https://developer.microsoft.com/en-us/fabric#/styles/themegenerator

Branding SharePoint: The New Normal (M365)
https://blogs.msdn.microsoft.com/bobgerman/2018/09/04/branding-sharepoint-the-new-normal/
https://bob1german.com/2018/09/04/branding-sharepoint-the-new-normal/

Office 365

Branding SharePoint: The New Normal

https://bob1german.com/2018/09/04/branding-sharepoint-the-new-normal/
Repost
https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/Branding-SharePoint-The-New-Normal/ba-p/241855

2013 / 2016

Composed Looks

Deploy a custom theme in SharePoint
https://docs.microsoft.com/en-us/sharepoint/dev/general-development/how-to-deploy-a-custom-theme-in-sharepoint

SharePoint 2013: Creating a Composed Look
https://social.technet.microsoft.com/wiki/contents/articles/30903.sharepoint-2013-creating-a-composed-look.aspx

Use composed looks to brand SharePoint sites
https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/use-composed-looks-to-brand-sharepoint-sites

Step by Step: Create a SharePoint 2013 Composed Look
https://bniaulin.wordpress.com/2012/12/16/step-by-step-create-a-sharepoint-2013-composed-look/

Create a SharePoint 2013 Theme using Color Palette Tool
https://en.share-gate.com/blog/create-sharepoint2013-theme-using-color-palette-tool

Branding Links Recommended by Students (Thx Jon)

http://sharepoint.stackexchange.com/questions/84412/modifying-top-navigation-through-css

https://kogzee.wordpress.com/2013/08/07/style-sharepoint-2013-top-navigation-global-navigation-menu/

http://www.sharepointdiary.com/2014/11/sharepoint-2013-top-navigation-bar-branding-css.html

http://www.macaalay.com/2014/01/28/how-to-remove-sharepoint-2013-quick-launch-andor-top-link-bar/

https://discoveringsharepoint.wordpress.com/2013/03/19/programmatically-set-navigation-settings-in-sharepoint-2013/

https://chrisstahl.wordpress.com/2014/03/31/customizing-sharepoint-2013-global-navigation-with-css-and-jquery-part-5/

https://social.msdn.microsoft.com/Forums/en-US/eed6e044-3c14-43cd-9885-2490a0121e79/move-top-navigation-bar-in-sharepoint-2013?forum=sharepointcustomization

http://stackoverflow.com/questions/25036569/sharepoint-2013-css-move-around-global-navigation-elements

https://wordpress.org/support/topic/move-top-nav-bar-down

http://en.share-gate.com/blog/create-sharepoint2013-theme-using-color-palette-tool

https://msdn.microsoft.com/en-us/library/office/jj927175.aspx

Themes

Team Sites to inherit master page and theme
http://www.sharepointeurope.com/blog/2013/7/22/sharepoint-branding-team-sites,-inherit-theme-and-master-page-on-office-365

Change the default theme of a site collection and future subsites.
http://sharepoint.stackexchange.com/questions/79750/is-there-a-way-to-change-the-default-theme-of-a-site-collection-and-fututre-subs

Composed Looks - Use composed looks to brand SharePoint sites
https://msdn.microsoft.com/en-us/library/office/dn985875.aspx
http://sharepoint-community.net/profiles/blogs/creating-and-applying-a-composed-look-in-sharepoint-2013
https://bniaulin.wordpress.com/2012/12/16/step-by-step-create-a-sharepoint-2013-composed-look/

All you need to know about site logo size in SharePoint 2013
http://blog.incworx.com/blog/sharepoint-administrators-blog/all-you-need-to-know-about-site-logo-size-in-sharepoint-2013

Branding

SharePoint Branding - Themes, Master Pages, and Page Layouts
Excerpt below from above …

Theme:
     - we want our logo
     - we want our colors
     - we want our fonts
     - we want background image
Master Page:
     - we want site logo to link to start page, not to subsites
     - we want another navigation
     - we want links on the top
     - we want footer on every page
     - we want a big banner on the top
     - we want breadcrumb
Page Layouts:
     - we want more content zones on the page
     - we want a content zone on the right for related links and content
Styling
    - we want 20px or 30px margins
    - we want larger headings (H1,H2,H3..)
    - we want border around content

Guide to quick SharePoint 2013 branding
http://blog.blksthl.com/2013/02/26/a-guide-to-quick-sharepoint-2013-branding/

Step by Step
http://www.sharepointempower.com/Blog/Post/3/SharePoint-2013-branding-step-by-step

Start Master Pages
http://startermasterpages.codeplex.com/

How do I apply master page changes to all subsites in SharePoint 2013?
http://sharepoint.stackexchange.com/questions/61979/how-do-i-apply-master-page-changes-to-all-subsites-in-sharepoint-2013

Hide Recent
http://sharepoint.stackexchange.com/questions/61347/how-to-hide-recent-in-the-navigation

Tips on Team Site
Recent Heading – current navigation (five most recent appear)
http://blogs.office.com/b/sharepoint/archive/2012/07/25/the-new-team-site.aspx

SharePoint 2013 Design Manager
http://sharepointfordeveloper.blogspot.com/2013/06/sharepoint-2013-design-manager.html
MSDN - Overview of Design Manager in SharePoint 2013
https://msdn.microsoft.com/en-us/library/office/jj822363.aspx

2010

Basics
https://www.nothingbutsharepoint.com/sites/eusp/Pages/Hack-SharePoint-Master-Pages-Introduction.aspx

Navigation
https://www.nothingbutsharepoint.com/sites/eusp/Pages/Brand-SharePoint-Global-Navigation-The-Journey-Begins.aspx

Mega Menu

http://www.nothingbutbranding.com/blog/2012/august/mega-menu-dropdown-sharepoint

Move Quick Launch – to the Right Side

http://www.nothingbutbranding.com/blog/2012/august/move-sharepoint-quicklaunch-to-the-right

Heather Solomon - great presentations on branding in 2007 and is now working on 2010
http://www.heathersolomon.com/blog/

SharePoint Deletion Log

SharePoint has a powerful report for file deletion in SharePoint 2016 / 2013.

Under Site Collection Administration > Site Collection Audit Settings
Turn on all events needed for audit, but remember this will significatly increase the size of your content database.

So consider turning on Audit Log Trimming which is end of the month by default
https://support.office.com/en-US/article/Configure-audit-settings-for-a-site-collection-F5A346D0-EE0F-4412-A5E6-D9B5ABAA1012



Next, lets create some activity using built-in document library.

Add and delete document.

Back to Site Collection Administration > Audit Log Reports > Deletion
 Save report (Suggestion: Create a new document library for audting)

Open Report using Excel or Excel Web App

Auditing in SharePoint

Articles

SharePoint 2016

Excel Import Permissions
http://www.sharepointdiary.com/2015/05/export-sharepoint-users-and-group-permissions-to-excel.html
Audit Specific Event ID Function
https://howtodowithsharepoint.wordpress.com/2016/11/26/sharepoint-20162013-event-log-monitoring-by-automation/

Configure audit settings for a site collection (2016)
https://support.office.com/en-us/article/Configure-audit-settings-for-a-site-collection-A9920C97-38C0-44F2-8BCB-4CF1E2AE22D2
More from The Cloud EngineerSharepoint Deletion Log
http://thecloudengineer.blogspot.com/2016/03/sharepoint-deletion-log.html

Office 365

Office 365 Audit Logging
https://www.petri.com/office-365-audit-logging-generates-data

SharePoint Legacy

SharePoint 2013

Enables auditing of how site collections, sites, lists, folders, and list items are accessed, changed, and used
https://msdn.microsoft.com/en-us/library/ms441917.aspx

SharePoint Server 2013 custom audit log report - PowerShell script
https://gallery.technet.microsoft.com/office/SharePoint-Server-2013-9657c24e
Using PowerShell Scripts to Implement SharePoint Audit Logging (part 1 and part 2)
http://www.coyotecrk.com/using-powershell-scripts-implement-sharepoint-audit-logging-part-1/
http://www.coyotecrk.com/using-powershell-scripts-implement-sharepoint-audit-logging-part-2/
View and configure usage analytics reports in SharePoint Server 2013
https://blogs.technet.microsoft.com/tothesharepoint/2014/01/23/view-and-configure-usage-analytics-reports-in-sharepoint-server-2013/
Auditing - A Built-in Feature of SharePoint 2010
https://www.codeproject.com/articles/431342/auditing-a-built-in-feature-of-sharepoint

More Tools

SharePoint Audit Logging

https://support.office.com/en-us/article/Configure-audit-settings-for-a-site-collection-A9920C97-38C0-44F2-8BCB-4CF1E2AE22D2

https://www.ultimatewindowssecurity.com/sharepoint/default.aspx

SharePoint Deletion Log Report

http://thecloudengineer.blogspot.com/2016/03/sharepoint-deletion-log.html

SharePoint Permissions Analyzer

TechNet - SharePoint PowerShell: Get list of all users present in a site under different SharePoint Groups
http://social.technet.microsoft.com/wiki/contents/articles/31301.sharepoint-powershell-get-list-of-all-users-present-in-a-site-under-different-sharepoint-groups.aspx
https://sppermissionanalyzer.codeplex.com/

Simple SharePoint Permissions Auditing – OOTB

The question is how do I view permissions and perform a site auditing using out of the box tools.  Using PowerShell script found from fellow Buckeye SPUG member Brian Jackett, I was able to create an excel report below.
https://briantjackett.com/2013/07/01/powershell-script-to-enumerate-sharepoint-2010-or-2013-permissions-and-active-directory-group-membership/
First I needed to add the policy at the web application level.
Second I ran the script and dumped out an xml file.
Finally results displayed by using Excel import from the XML file for a small lab setup.

Displaying XML in SharePoint

http://thecloudengineer.blogspot.com/2015/11/displaying-xml-in-sharepoint.html

Auditing - A Built-in Feature of SharePoint

http://www.codeproject.com/Articles/431342/Auditing-A-Built-in-Feature-of-SharePoint

SharePoint Foundation

http://auditlogsp.codeplex.com/
2010

• SharePoint 2010 Audit Configuration
• SharePoint 2010 View Audit Log Reports

Project Honolulu – Management Tool

Microsoft Project Honolulu

Install was smooth on Windows 10, but …

Run as different user since Edge is needed and won’t run as domain admin

Run winrm quickconfig

Alternate Creds needed

Up and running in a few minutes and looks nice.

Yeah !!! powershell remote

Download
https://aka.ms/HonoluluDownload

Reference
https://docs.microsoft.com/en-us/windows-server/manage/honolulu/honolulu

Note WMF 5.1 prerequisite download WMF 5.1.

More Info

Why SharePoint? – What is the Value?

SharePoint 2016

8 reasons why Intranet in SharePoint rocks!
http://sharepointmaven.com/why-sharepoint-intranet-rocks/

Business Value and SharePoint
http://www.expertsofsharepoint.com/business-value-sharepoint/

Office 365

Reinventing business processes in SharePoint and Office 365
https://techcommunity.microsoft.com/t5/SharePoint-Blog/Reinventing-business-processes-in-SharePoint-amp-Office-365/ba-p/69260

SharePoint 2013

How IT Can Pitch SharePoint for Business Decision Makers
https://www.avepoint.com/blog/avepoint-blog/can-pitch-sharepoint-strategic-business-platform-decision-makers/

Why Use SharePoint?
https://en.share-gate.com/blog/why-use-sharepoint-its-benefits-between-two-farms

What business value does SharePoint provide?
https://www.winxnet.com/blog/blog-home/sharepoint-business-value/

Older Legacy

Found good article on why should you use SharePoint

http://www.onsearchinteractive.com/microsoft-sharepoint/fully-leveraging-microsoft-sharepoint-questions-to-ask/

Would you like to provide your employees with an internal website/platform where employees can communicate, share/store documents and content, collaborate on projects/documents, search for internal information and expertise, execute business processes online (i.e. submit an expense report for approval), and consume business information for decision making (i.e. business intelligence)

How do employees learn about new business process, policies, or any other important communication?
Are you only relying on email?
How do employees access company applications, services, forms, contact information, and documents?
How do employees find certain expertise within the company?
How do employees collaborate in projects?
Do your employees take online training today?
How do employees share the projects that are working on, their interest or any other info that may be relevant to the rest of employees?
Do you know how much time your employees spend searching for info and the cost of that time?
How are you dealing with business process/document approvals? (i.e purchase requests, travel expense)
How do you access the company directory? Is it visual? Can you see the relationship of employees?
If an employee left right now and sue the company, how would you lock all the content he was involved?
Do you have document retention/archive plans or policies and if so what are they?
How do you manage records for compliance (i.e. controlling changes to document such as policies, declare records so they cannot be edited or deleted and sent to the proper record center)
How are forms being handled today? (i.e. in paper)
How are you managing version control?
What about auditing of documents?
How are forms being handled today? (i.e. in paper)
How does IT manage the onboarding process? (ie. assign PC, give access to email, etc)
How much is spent in paper and document storage on a monthly basis?
How do you collaborate in projects with parties outside of the company?
How do you manage the publication of web content today?
How is the procedure to upload and store documents?
How do you control access to documents?
How are documents signed today? (i.e. paper)
How does management get information/reports on Key Performance Indicators (KPIs)?

All solved by SharePoint

SharePoint Performance Optimization and Scale

2016

Optimize Performance
https://technet.microsoft.com/en-us/library/jj721440(v=office.16).aspx
Planning Performance
https://technet.microsoft.com/en-us/library/cc262971(v=office.16).aspx

2013

How To Calculate Number of web front end servers in a SharePoint farm 2013 and 2010
http://abhayajoshi.blogspot.com/2014/01/how-to-calculate-number-of-web-front_24.html

Capacity management and sizing for SharePoint Server 2013
https://technet.microsoft.com/en-us/library/cc261700(v=office.16).aspx

Optimize Performance
https://technet.microsoft.com/en-us/library/jj721440.aspx
Planning Performance
https://technet.microsoft.com/en-us/library/cc262971(v=office.15).aspx

2010

Scaling SharePoint
https://technet.microsoft.com/en-us/library/cc261795(v=office.12).aspx

Interacting with Data Collector Sets via Powershell
http://blogs.technet.com/b/brad_rutkowski/archive/2009/02/18/interacting-with-data-collector-sets-via-powershell.aspx
http://social.technet.microsoft.com/wiki/contents/articles/7926.sharepoint-2010-tips-for-dealing-with-performance-issues.aspx
Great list of Links on SharePoint Performance
http://www.sharepointedutech.com/2011/10/09/spc373-performance-tuning-sharepoint-2010/
http://www.slideshare.net/joeloleson/sharepoint-performance-optimization-in-10-steps-for-the-it-professional

Developer Performance Tools (Visual Studio Solutions)
SPDisposeCheck is a tool that helps developers and administrators check custom SharePoint solutions that use the SharePoint Object Model helping measure against known Microsoft dispose best practices http://blogs.msdn.com/b/rogerla/archive/2010/12/13/announcing-spdisposecheck-v14-0-4762-1000-update-for-sharepoint-development.aspx

IIS
w3wp.exe using too much memory and resources
http://blog.whitesites.com/w3wp-exe-using-too-much-memory-and-resources__633900106668026886_blog.htm

SAN
Great Video and scripts to help diagnose issues (SAN or not)http://www.brentozar.com/archive/2011/08/how-prove-its-san-problem-webcast-video/

SQL Performance Tools

SQLIOSim - For Microsoft SQL Server 2005, SQLIOSim was shipped as a separate download package. Starting with SQL Server 2008, SQLIOSim is included with the SQL Server product installation http://support.microsoft.com/kb/231619
SQLIO - Microsoft Utility used to determine the I/O capacity of a given configuration.
http://www.microsoft.com/download/en/details.aspx?id=20163

Other Performance Tools

Logman and powershell
http://colleenmorrow.com/2012/02/13/using-powershell-to-deploy-performance-monitor/
Team Foundation Server with Test Edition
Jumble
Grinder
OpenSTA
Fiddler2
webpagetest.org
perfmon
SQL Server Management Studio
Firebug and Firebug lite
HTTP Watch
IE Dev Tool Bar
Temp DB
Separate Disk
Watch Disk Space
Compact
Watch Memory
GZip

OLD

http://blogs.msdn.com/b/sanjaynarang/archive/2009/04/18/sharepoint-performance-stress-load-testing.aspx