Writing HTML in Calculated column formulas
Hello all, I want to write HTML in the calculated column formula. Field 1: Status Field Type: Choice field. Values are Not Started, Published Field 2: DisplayStatus Field Type: Calculated The DisplayStatus calculated field will display text followed by a line break or new line character and then followed by some text. So I want to achieve this but not sure about the syntax =IF([Status]="Not Started","Text1 <BR> Text1", IF([Status]="Published","PubText2 <br> PubText2", "NA")) Need help with the formula... Thanks all.
April 2nd, 2010 7:04pm

Hi, Can you try this formula: =IF([Status]="Not Started","Text1 <br/> Text1", IF([Status]="Published","PubText2 <br/> PubText2", "NA")) If the above does not work: Try replacing <br/> with Shift + EnterBR, PM
Free Windows Admin Tool Kit Click here and download it now
April 2nd, 2010 8:23pm

<br/> did not work and it comes up as text. How do you put Shift + Enter to replace <br/> in the formula? Thanks for the suggestions...
April 2nd, 2010 8:29pm

Hi, Please read the related post in http://marijnsomers.blogspot.com/2010/01/write-html-code-in-sharepoint-via.html Hope this helps to shred a little night. Thanks! Stanfford
Free Windows Admin Tool Kit Click here and download it now
April 5th, 2010 6:35am

check this calculated columns formulas referrence http://blog.raminassar.com/2011/11/13/examples-of-using-calculated-column-formulas/Regards, Rami M. Nassar (MCP, MCTS, MCPD) My Blog E-Mail Don't forget to click Mark as Answer on the post that helped you.
November 13th, 2011 4:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics