Forum Discussion
JohnMald
Oct 26, 2021Copper Contributor
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]
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
JohnMald Try using below formula:
=IF(ISBLANK([IC]), "", [EAS] - [IC])
Note:
- 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:
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.
- IlseHattinghCopper Contributor=if(isblank([IC]),"",[EAS]-[IC])