New answers tagged

3

SharePoint stores dates as integer count starting at 1/1/1900 So =EndDate + 15 gets you 15 days from your EndDate To format Dates different you can use the TEXT() function =TEXT( EndDate+15 , "YYYY/MM/DD" ) Function documentation: http://viewmaster365.com/365coach/#/Calculated_Column_Functions_List


0

Try putting the column name in square brackets like [Approval_x0020_Date]. The name should be the internal name of the column.


0

Why don't you go for a Lookup field? Create a Separate List with Hindu Muslim and Christian category with their corresponding values and then call this list as a lookup column in your List. You will get easy guidance on creating lookup fields in internet.


0

If you are using SharePoint 2013 or 2016 this is not difficult. Lets assume that your date field is "RecordDate" and the text field is "RecordText". If you create a managed property of the same name for each you should be able to use the query RecordDate>={Today} OR RecordText="ABC"


0

You can simply use below formula in calculated field. =SUM( if([Col1]="High",3, if([Col1]="Med",2, if([Col1]="Low",1,0))) , if([Col2]="High",3, if([Col2]="Med",2, if([Col2]="Low",1,0))) , if([Col3]="High",3, if([Col3]="Med",2, if([Col3]="Low",1,0))) , if([Col4]="High",3, if([Col4]="Med",2, if([Col4]="Low",1,0))) ) Please let me ...


0

You can try using conditional formatting.It is described in details here You can also try using jquery. You have to add a script in Edit Page\Edit Webpart\Miscellaneous and add the script in the JS portion(see the above link to find the exact location and then use the following script) Here is a sample of the script. Edit it as per your requirement: ...


1

Note that Impact * Probability * IF([Internal Control Score],[Internal Control Score] , 1 ) gives you the calculation in one statement


1

Try this: =IF( ISBLANK([Internal Control Score]) ,IF( Impact*Probability<=4 ,"Low" ,IF( AND(Impact*Probability>4,Impact*Probability<=12) ,"Medium" ,"High" ) ) ,IF( Impact*Probability*[Internal Control Score]<=4 ,"Low" ,IF( ...


1

Overly complex to use AND =IF( Col<36 ,"Low" ,IF( Col<71 ,"Med", IF( Col<106 ,"High", ,"Very High" ) ) )


0

=IF(AND(Col>=0,Col<=35),"Low", IF(AND(Col>=36,Col<=70),"Med", IF(AND(Col>=71,Col<=105),"High", IF(AND(Col>10),"V High","")))) Consider Col is your column name from which you want value to be evaluated .Try this Formula Added extra condition, if value is less than 0 this column will return blank value


0

If you go with Workflows and List views it will become really complicated. There is no harm in using SharePoint JavaScript API's. Just add a script editor webpart and query the list using CAML + JSOM. Loop the requests and add up total applied. Then subtract it from total allowed per year.


0

There are a few approaches, all with varying degrees of feasibility. Option 1 Continue to use an on creation workflow, but alter the logic a little to check if the calculated date is greater than today, if so, pause until that date and then continue on. This can work, but if the date changes while the workflow is paused, it can lead to unexpected or ...


1

One way you could do this is to open up SharePoint Designer and create an item workflow in passenger list(triggered on Create or Modified) for the passenger list. Create a parameter in the workflow for each bus type and for add a value to the correct parameter based on some if statements. Once you have those parameters you could loop through the items on ...


0

This is easy done with JavaScript: Retrieve Function will be something like this: var siteUrl = '/sites/MySiteCollection'; function retrieveListItems() { var clientContext = new SP.ClientContext(siteUrl); var oList = clientContext.get_web().get_lists().getByTitle('ListName'); var camlQuery = new SP.CamlQuery(); ...


0

Sure, this is possible with the Calculated Formula TEXT() See: http://viewmaster365.com/365coach/#/Calculated_Column_Functions_List for all Functions, take some time to read them all and see which one are of interest


0

You can use a calculated column and use a formula like this =CONCATENATE("<a href='mailto:",[email],"'>",[Name],"</a>")


0

I think so. Best approach is to read (all) SharePoint Formula Functions (there are not that many), read the Description & examples and see what matches your need http://viewmaster365.com/365coach/#/Calculated_Column_Functions_List


1

I think this maybe what you are looking for but we completely need more information like "What you are really looking to accomplish;" Try... =IF([Modified]>[ColumnA], [Modified], IF([ColumnA]>[ColumnB], [ColumnA], [ColumnB]))


0

SharePoint does not record when a COLUMN value changed; if you need that you must create a Workflow and do the administration yourself If you mean you want the maximum value of the 3 columns: DateA or DateB or Modified (SharePoints last registered anything-in-the-ITEM changed) it is: =MAX( [DateA] , [DateB] , [Modified] ) ...


1

Column C formula is =IF([ColumnA]>[ColumnB], [ColumnA], [ColumnB])


2

You can use the MAX function and output it in Date format. =MAX([date1],[date2]) If the two dates are blank, it will output a default date in 1899, so maybe put in a IF condition in there.


0

It is not the datediff that is causing the problem. That function does return 0 when you have the same date with different times. I am not familiar with the formula that you used but I noticed that it is adding 1 day to the datediff result. Tested the formula without the +1 and it looks OK. Give it a try (replace the column names before, and I had to ...



Top 50 recent answers are included