New answers tagged

0

Add another calculated field which gives you the difference between StartDate and HireDate. Now before each pause add a condition that checks the number of days. In case of enough days then do pause.


0

Have thought of making a workflow that loops every 24 hours while it is not completed that updates the duration. It would look like(sudo workflow) Loop until status = completed Wait until time add 24 hours(or whatever interval) to time do calculation between today and created set field duration to = calculation


0

You will need to use a custom workflow . You may think to add a lookup field to one of your lists to display actual level then created a calculated field between both fields. but unfortunately, you will notice that Lookup fields do not show under the Insert Column heading. Lookup columns cannot be referenced in a calculated column. The suggested ...


2

Sadly a lot of things don't work as expected in CSOM. As a last resort I have a small hack - simply open the desired page as iframe, modify the content and submit the page. Quite slow but at least it works. //quite dirty hack but at this point the only possibility to set the localized formula via clientside function setFieldFormula(listGuid, ...


0

The Lookup columns (or any complex datatype like user, multiple select) are not available to Calculated Columns. But (most of) the data is available in the JavaScript ctx.ListData object when the Page is built (I am not 100% sure SP2010 had the full functionality) Type ctx.ListData in the F12 Dev console to explore what is there You can use it in a ...


1

The OR is for boolean values (2 conditions) not for multiple possibilities for the = sign. This should work: =IF(AND([Expiration Date]<[TODAY]+180, OR([Current Status]="ACTIVE",[Current Status] = "EXPIRED")), "HIGH", IF(AND([Expiration Date]<[TODAY]+180, [Current Status]="RENEWED"), "NO ACTION REQUIRED", "NORMAL")) You were also missing several ...


0

I wanted to give an additional answer - since I had the exact same question as stated by the O.P. - but my problem turned out to be of a completely different nature... Initially, my conditional formatting logic (an advanced expression) - at the point I made it depend on a calculated column, it seemed to stop working. However, the actual culprit wasn't the ...


1

SharePoint syntax is exactly the same as Excel. =IF( condition1 , IF( condition2, TRUE , FALSE) , IF( condition3, TRUE , FALSE) ) So for complex Formulas its possible to create/test in Excel (with named ranges) and paste the Formula to SharePoint !! SharePoint has the limitation of maximum 7 levels deep nested calls !! See http://www.viewmaster365....


0

You can nest if statements as below =IF(PursuitStatus="Win", "Win", IF(PursuitStatus="Loss", "Loss", "Pending")) In the place of pending you can add remaining if conditions


0

If you want to do it with client-side code take inspiration from: How to use Today and Me in Calculated column Create unique number with ListItem [ID] and [Today] age in Calculated Column Formula Calculated formulas for tracking progress Help with Dual Javascript countdown clock Can I add a start workflow link to a column in a list view?


1

I think that what you're thinking will work. You'd have to write a workflow to pause for 24 hours, then update the item so that the calculated columns got updated. Or you might just set the values from the workflow rather than using a calculated column. If you're in 2013, you could loop the 24-hour pause in a while statement to stop running once the ticket ...


1

How can I implement a calculated column having return type 'single line of text' and the column should be a hyperlink. Not, outputting HTML is an undocumented feature that only works with non-Text datatypes Datatypes: Single Line of Text outputs the Calculation result as bare text (showing all HTML tags) Number outputs correct HTML, but wrapped in an ...


0

The shortest dev cycle time would be to keep 80 pieces of data in identical ways and write your interface to reuse the code as much as possible. Also, minimize the number of fields per query, and queries per view. You will note from the example that this format scales well. The single field could be as easy as a hash where you use 2 bits for each item and ...


1

Use a SharePoint Designer workflow, started when the item is created, to wait for the item to be closed. Wait for Status to equal Closed Set Closed On to Today You shouldn't use a calculated column, nor a workflow with an if statement, as some are suggesting. If the item is opened in edit mode any time after it's closed, and then saved (even if there are ...


1

Create calculated column Closed On with below formula: =IF(Status="Closed",Modified,"") Select Date and Time as data type for calculated column.


0

Open SharePoint Designer. Open the website that contains your list with the calculated column. Click on "Lists and Libraries" in the left column (under Site Objects). On the right, click on the list that contains your calculated column. Under "Content Types", click on the content type then check your calculated column name . In the content type screen, ...


0

You can achieve this by using Ite mAdded event receiver. Whenever an item will be added your custom code within above event receiver will be excuted. Steps:- 1.Retreive all list item using query which was created today. 2. If itemCount is 0 ,then there is no item created today ,so assign value to that field for new item using below format Value=DateTime....


0

I usually use a helper list when I'm having this requirement. The helper list has the following columns: Title | Modified |Index ----------------------------------- SomeUniqueTitle | 01.01.2016 | 1 When an item is created, a workflow will be started. The workflow checks the Modified date of that specific item in the helper list. If ...


0

I have just got off the phone with Microsoft and it appears that calculated columns are not support in Gantt Chart views for tasks. My workaround will be to run a workflow to copy the date of the calculated column into a normal date column.


5

The ID field you are trying to use in your Calculated Column is not known until the Item is saved . Hence using it in your calculated column may not give you the required output.You can use an event handler or a workflow to update the list items. My preference would be a simple workflow that runs when the items are created.


0

You can achieve this without (re)creating an existing auto incrementing field, ID. Simply create a view in your list that is grouped by event and add a Count in the Totals section of the view configuration. This will group all the respondents together based on the event and give you a total of responses.



Top 50 recent answers are included