Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
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
Avatar of Serena Hsi
Serena Hsi
Flag of United States of America image

Avatar of Matt Pinkston
Matt Pinkston

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
ASKER CERTIFIED SOLUTION
Avatar of Serena Hsi
Serena Hsi
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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]>="Cancelled",[Status]>="Complete")),SUM([Date Complete]-[Date Entered),"rejected")