Calculated Column in Sharepoint with IF statements

Question

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

If the column 'Date Project is Completed/Cancelled' is populated, then Age = 'Date Project is Completed/Cancelled' - 'Date Assigned'
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])

score 1 · Answer 1 · edited Jun 05 '17 at 19:53

1

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)

edited Jun 05 '17 at 19:53

answered Jun 05 '17 at 19:18

I can use e.g. Today() + 30 in the calculated column, am I missing anything? – SharePointer Jun 05 '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? – Danny '365CSI' Engelman Jun 06 '17 at 06:47

1 Answers1