Tag Info

New answers tagged

0

You can use a sub-string type of formula. Though sub-string itself is only available in forms and workflows (not calculated columns) you can write one of your own (use LEFT, RIGHT, FIND, LEN). See example


0

Depends on what you are going to do with this. If you are going to just look through the data then a view like Nadeem suggested is your solution. If you are looking to use this in a workflow to do something with the data based on that date then it gets a bit more tricky. List items won't update daily unless you manually change the record. This prevents ...


3

You can create a view in the list which will show items based on the formula. For example, if you want to see items which have been created during Past 90 days, the formula will be Created is greater than or equal to [Today]-90.


0

If you are unable to get the HTML to render when the calculated column's data type is set to Number, you can try a different approach. Add a rich text field to the list and copy the value from the calculated column to the rich text field via a SharePoint Designer workflow that triggers when items are added or updated. You can hide the rich text field ...


0

Assuming your users are entering items via the New Item form, rather than via datasheet view or inline editing, you can add JavaScript to the New Item and Edit Item forms that will retrieve the content type ID from the query string parameters (if specified) and store it in a text field on the form. You can then reference that text field instead of ...


0

Possibly you can write some jQuery and Javascript and fix it in the browser instead of the Site Columns. It is easier to maintain and does not contain any Server Side code.


0

So I presume User1 can have multiple rows in the list. A Calculated Column can only do calculations within one row. With you OOB request I would say: You can try the SharePoint Designer Workflow route where you find all Rows of User1 and calculate an average. (and then store it somewhere) You can use a Calculated Column with some (consealed) HTML and ...


0

There is a hack that solves that problem (that is by design on the other hand, and is there since SP 2010) without SharePoint Designer. Define your calculated field as date or number instead of text, and it won't be HTML escaped any more. See 4. The HTML Trick in this post for example. Of course you can use SPD if you wish, but I definitely would not ...


0

As per my understanding there are two solutions to this 1. Using client side scripting In this case you should edit the new/edit form and add JavaScript which goes and check if FirstName + ' ' + LastName already exists in the list. For that you can use SPServices and then handle this validation on PreSaveAction method. This approach will provide a good ...


0

For sorting purposes (i.e. Ascending sort and Descending sort) on the month I usually do the following: =CONCATENATE(TEXT([Some Date Column],"MM")," : ",TEXT([Some Date Column],"MMM")) This results in the format: 01 : Jan Which then allows you to set up a View where you can correctly sort by Month.


1

The next option with you is to create a Workflow using SharePoint Designer. Run the workflow on item create and item update. Change the field FinalDate to a DateTime Create a new workflow and attach it to the List in question In the workflow using DateFunction you can add the value into a variable Use Update Current Item activity and update field ...


0

Please maintain proper code syntax. You should note, it may have trouble parsing the text. You need brackets, and don't try to join strings together without concat. Try this: =IF(ISBLANK([AuthorTxt]),[Title],CONCATENATE([Title]," ",[AuthorTxt]))


0

If I were you I would split up your Tickets list into two lists (Master tickets & Problem tickets). Then use a lookup from the problem list to the master list to create that relationship. That way it's not all in one record for each one and you have a central place to manage the master tickets. For your Combined Service Indicator it could be a bit ...


0

You can try using list relationships. Create a new look-up column in List A that references List B, if it returns data you have your match. If all you need to do is report on the data you can also just use Excel. Use PowerPivot and import the two lists as data sources, and do essentially the same thing. With PowerPivot however you have a lot of ...


1

You will need to have 1 column to store information then another for the calculated value. Using a workflow, you would log the modified date in your first column when the status is set to complete. Then your calculated column would be something like =[Column1] - [Created]



Top 50 recent answers are included