Forum Discussion
SharePoint Calculated Column Date IF/Then
nimesht Thanks for pointing out the error. One closing bracket was misplaced.
Here is corrected formula (also corrected in above response now):
=IF(ISBLANK([Resubmit Date]),IF(ISBLANK([Extend Date]),"",[Extend Date]-14),[Resubmit Date]-14)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.
THough335 Use this formula:
=IF(ISBLANK([Resubmit Date]),IF(ISBLANK([Extend Date]),"",[Extend Date]-14),[Resubmit Date]-14)
Note: Sometimes comma( , ) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon( ; ) instead of comma( , ).
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.
- I see error in formula, nested parameters are not placed correctly so the last if has 4 parameters instead of 3
nimesht Thanks for pointing out the error. One closing bracket was misplaced.
Here is corrected formula (also corrected in above response now):
=IF(ISBLANK([Resubmit Date]),IF(ISBLANK([Extend Date]),"",[Extend Date]-14),[Resubmit Date]-14)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.
ganeshsanap Thank you sooooo much for your assistance! It worked. Yay!
