Hot answers tagged calculated-column
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.
You could try the FIND formula for this one. e.g. Check if "ABC" contains "A" =FIND("A",[Column1]) For more details, check out this link.
Consider Requester Name field contais value as Nagarajan Muthukumar Formula for First name: (LEFT([Requester Name],INT(FIND(" ",[Requester Name])-1))) Result in First Name: Nagarajan Formula for Last name: RIGHT([Requester Name],LEN([Requester Name])-INT(FIND(" ",[Requester Name]))) Result in Last Name: Muthukumar If the Name is Nagarajan M Muthukumar (...
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 ...
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....
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 ...
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 ...
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 ...
Create calculated column Closed On with below formula: =IF(Status="Closed",Modified,"") Select Date and Time as data type for calculated column.
Only top voted, non community-wiki answers of a minimum length are eligible