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