Forum Discussion

JohnMald's avatar
JohnMald
Copper Contributor
Oct 26, 2021

How to null date if blank

Hello,

I am trying to create a calculated column using the formula but want the calculated filed to be blank if the “IC” date is blank. Can someone help please

=[EAS]-[IC]

2 Replies

Sort By
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Oct 27, 2021

    JohnMald Try using below formula:

     

     

    =IF(ISBLANK([IC]), "", [EAS] - [IC])

     

     

    Note:

    1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

    Official Documentations:

    1. Calculated Field Formulas
    2. IF function

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources