Hot answers tagged

3

Regarding the error you are receiving, if you are using different regional settings than English in your site, try to replace all the commas (,) to semicolons (;). You could make a easier calculation to. This one returns the number of days, hours and minutes between the 2 dates. =TEXT([Fin Diag]-[Debut Diag];"d:h:mm") Update Tried out your calculation ...


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.


1

Since SharePoint doesn't really care about Types. Blank Dates values are False values, and valid Dates are True values, So Erin was the closest, just had a too long Formula =IF( AND([Date 1],[Date 2]) , DATEDIF([Date 1],[Date 2],"D") , "" )


1

Check if one of the value is empty, if it is, return blank, else calculate the difference. =IF(OR(ISBLANK([Date 1]),ISBLANK([Date 2])),"",DATEDIF([Date 1],[Date 2],"D"))


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" ) ) )


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 ...


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]))


1

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



Only top voted, non community-wiki answers of a minimum length are eligible