I would like to use two formulas to define the field 'Age'.

  1. If the column 'Date Project is Completed/Cancelled' is populated, then Age = 'Date Project is Completed/Cancelled' - 'Date Assigned'

  2. If the column 'Date Project is Completed/Cancelled' is not populated,
    then Age = 'Current Date' - 'Date Assigned'

This is the formula I used but SharePoint will not accept:

=IF(ISBLANK ([Date Project is Completed/Cancelled]), [Current Date] - [Date Assigned], [Date Project is Completed/Cancelled] - [Date Assigned])

See all answers at: How to use Today and Me in Calculated column

You can not do Current Date calculations in a Calculated Column

The comparison part of your IF is with the OR function:

=IF( OR( [Date Project]="Completed" , [Date Project]="Cancelled"), TRUE, FALSE)
  • I can use e.g. Today() + 30 in the calculated column, am I missing anything? Jun 5 '17 at 20:54
  • 1
    You are missing a lot, read that How to use Today post... for the longer explanation Calculated Formulas are only modified/updated when an Item Changes (or the Formula is updated) ... so what is the value when you wait 24 hours? Jun 6 '17 at 6:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.