1 min read

 Often you want a view to be nicely formatted and be a set height amount.

 This is how to do it.

 =IF(LEN(Description)>140,CONCATENATE(“<DIV>”,LEFT(Description,140),”<a href=’http://SPSite.com/Site/ListName/_layouts/FormServer.aspx?XmlLocation=/ SPSite.com/Site/ListName/”,Title,”&Source=’http://SPSite.com/Site/ListName/Item&DefaultItemOpen=1′>… (click here for more)</a></DIV>”),Description)

 Pretty easy code to put in a view.