Share via

SharePoint Online Calculated Field Support for Blanks

Gene Olsen 0 Reputation points
2023-12-14T23:35:55.2566667+00:00

=IF([Revised Planned Date]="",PlannedFinishDate,[Revised Planned Date]) is the one working

However,

If Both Revised Planned Date and Planned Finish Date are blank show blank.

Currently shows 12/30/1899 in my output when both are blank.

Microsoft 365 and Office | SharePoint | Development
Microsoft 365 and Office | SharePoint | For business | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Gene Olsen 0 Reputation points
    2023-12-15T00:10:59.9666667+00:00

    =IF(PlannedFinishDate="","",IF([Revised Planned Date]="",PlannedFinishDate,[Revised Planned Date]))

    0 comments
  2. Emily Du-MSFT 51,846 Reputation points Microsoft External Staff
    2023-12-15T03:32:24.3+00:00

    Based on your original post, I understand that if Both Revised Planned Date and Planned Finish Date are blank, the calculated column shows blank. If not both Revised Planned Date and Planned Finish Date are blank, the calculated column shows the value same as Revised Planned Date. If I misunderstand your requirement, please correct me.

    You could use following formula in the calculated column.

    =IF(AND(ISBLANK([Revised Planned Date]),ISBLANK([Planned Finish Date])),"",[Revised Planned Date])

    Result:

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.