Matt Pinkston
asked on
SharePoint List Calculated Field
Trying to figure out if you can combine things in a sharepoint calculated field...
My list has the following fields
Status
Todays Date
Date Entered
Date Due
Date Complete
I want a calculated field that would be
Todays Date - Date Due IF Status is not equal to complete
My list has the following fields
Status
Todays Date
Date Entered
Date Due
Date Complete
I want a calculated field that would be
Todays Date - Date Due IF Status is not equal to complete
ASKER
Thanks but what I don't understand how to do is to combine things
If Status NE Complete or Cancelled Then calculate Todays Date - Date Due
If Status NE Complete or Cancelled Then calculate Todays Date - Date Due
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So in my scenario
If Status does not equal Cancelled AND status does not equal Complete
Then
The value should be Date Complete - Date Entered
Else
The value should be Todays Date - Date Entered
Will this work?
IF(AND([Status]>="Cancelle d",[Status ]>="Comple te")),SUM( [Date Complete]-[Date Entered),"rejected")
If Status does not equal Cancelled AND status does not equal Complete
Then
The value should be Date Complete - Date Entered
Else
The value should be Todays Date - Date Entered
Will this work?
IF(AND([Status]>="Cancelle
=DATEDIF([Column1], [Column2],"d")
Also, here's how to calculate using [Today]
https://social.msdn.microsoft.com/Forums/office/en-US/0853b2c5-a1ab-4f02-b597-bdd828004318/sharepoint-calculated-column-with-today?forum=sharepointdevelopmentlegacy
or, http://manas-pradhan.blogspot.in/2011/12/using-today-calculation-in-sharepoint.html