Tag Info

Hot answers tagged

4

I reformatted the Formula in your original post, you can copy/paste multilines and SharePoint will ignore them. The = was allready spotted; You are also missing a False in your second IF =IF([Course #]="AWR135" ,"Promoting Community Cybersecurity Planning" ,IF([Course #]="AWR136" ,"Essentials of Community Cybersecurity" ,"" ...


3

The Number trick to display HTML only works in Views, it shows the bare HTML on Forms and in Alerts. Full explanation and pros & cons at: http://viewmaster365.com/index.html#/How For Forms you have to go for Client-Side-Rendering (CSR) BTW Your Formula: =IF(Area="HR" ;"<div><img style='float: left' ...


2

You can accomplish this with a calculated field and a view. Create a calculated field named Month and use the Date In or Date Out field (which ever you want to use to count occurrences). The calculation for this column will be =TEXT([DateField], "mm"). This will return the month as a numerical value. Now that you have this, create a view or modify an ...


1

In 2013 its best to apply CSR with a JSLink, but this method has some drawbacks like having to set the JSLink for every View, and not being able to (easily) have multiple Views on one page. In SP2010 I used these steps to Sum a Calculated Column (which can not be done with a View Total) It uses Javascript in a Calculated Column to do the math while the ...


1

below formula should work for you Try this: =IF([Course#]="AWR136","Promoting Community Cybersecurity Planning",IF([Course#]="AWR135","Essentials of Community Cybersecurity"))


1

Here are the sites you may want to read: CSR - Client Side Rendering The SharePoint 2013 programmers way http://www.viewmaster365.com/#/How Yes you can display HTML/Javascript without the need for CSR, in a Calculated Column How to use Today and Me in Calculated column How to display Today calculations in a View with JavaScript in Calculated Column (or ...


1

It is true that I need to go for CSR. I went into the edit mode on the DispForm view for one of my items. Go into the Web Part attributes -> Miscellaneous Enter the JSLink to your file (in my case it is ~sitecollection/SiteAssets/logo.js) Sharepoint is showing my HTML code as a text string and for this I simply exchanged the innerHTML with my innerText. ...


1

Just an idea to accomplish your requirement in a different way is to use CSR. I think the pro's of CSR are in your case: Only one column You can sort by column and get the real name instead of the html code Easy to use in different libraries If you have questions about the tutorial, don't be afraIT to ask.



Only top voted, non community-wiki answers of a minimum length are eligible