The purpose of this post is to help readers who are having trouble implementing my “HTML calculated column” method. Below are some of the most common issues.
SharePoint returns an error message when you create your calculated column
– Do not directly copy/paste the formulas from my blog. Use “copy to clipboard” when available, otherwise type it directly in the formula field of your calculated column.
– Start by implementing one of my examples as is. Choose for example the indicator, which works on a standard issues list.
– You can use the “Edit in Datasheet” option to edit your formulas. In datasheet mode, SharePoint provides some context help.
The formula works, but it is rendered as is, not as HTML
– Remember that the formula itself does nothing, you also need the script, provided through a CEWP placed in your page.
– Do not put the script in the text editor of the CEWP. You can either put it in the source editor, or (recommended) put it in a separate text file and link to it from the CEWP.
– The CEWP must be placed AFTER the list on the page.
– The CEWP is needed on every page where you need to render the HTML.
You don’t know the syntax for SharePoint formulas
You can find some useful references in this post.
The HTML is not rendered correctly
You may have a syntax error in your HTML, double check your opening and closing quotes, as well as semi-colons in styles.
For Firefox, do not forget the non-breaking space when needed (see my posts for examples).
If you cannot get the method to work, you have two ways to ask for advice:
– post your question in the comments section. To post code, use the following syntax: