Tag Info

New answers tagged

0

I figured it out just incase any of you want to do something similar: =CONCATENATE("<div><a href='http://hsvspsd01vm/Lists/Play%20List/DispForm.aspx?ID=",[Link ID], "'>Link to Information</a></div>") Link ID has to be filled out but at least you can create a semi-dynamic link here :)


0

Do this is a Sharepoint Designer Workflow. But first set up your field. Delete the calculated field and create a number field. [Annualised Savings] Set the WorkFlow to start Automatically... in your first Workflow Step Set your condition Compare list field Say if [Annualised Savings] is Empty. Then add as your action Do Calculation ...


0

There are at least 2 more things that you need to take into consideration when using calculated columns with content types: Each column referred to in the calculated column must also be a site column added to the content type - The point here is that you cannot do things like reference a list level column in a content type level column because once you ...


0

I found the solution my self. I would like to share it with you. Go to the calculated column settings. There you can implement formula. On the right you can see the columns. Just double click on the column you would like to show in the calculated column.


0

BTW, you haven't closed the FieldRef tag.


0

Even though your calculated column has the correct type ("number") in SharePoint, you may need to explicitly cast the variable to type number. That's much easier than it sounds. Do the following in SPD: Setup your condition and style the way you want them Go into Code view and look for <xsl:attribute name="style"> Change your condition from ...


0

One would think that string manipulation were a trivial thing to do through either a calculated column or a workflow. The -sad- truth is that none of the two are of help for this specific task. calculated columns: the problem is that (unexplicably, at least to me) they don't support the SUBSTITUTE function, so, although possible with a complicated ...


0

Try this: =REPLACE([YourColumnname],FIND(";",[YourColumnname]),1," AND ") This should get you going in the right direction. Calculated Field Formulas The column "NewColumn1" is using the exact formula as above, and was created from the SharePoint Designer. I Don't know why it did not work from the UI. I'm using the default language pack. REPLACE ...



Top 50 recent answers are included