Forum Discussion

THough335's avatar
THough335
Copper Contributor
Aug 04, 2023
Solved

SharePoint Calculated Column Date IF/Then

I have a SharePoint list with three date columns.  Resubmit Date can have a value OR  Extend Date can have a value.  Based on which column has a value I would like that column to minus 14 days from t...
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Aug 07, 2023

    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.

nimesht's avatar
nimesht
Iron Contributor
Aug 07, 2023
I see error in formula, nested parameters are not placed correctly so the last if has 4 parameters instead of 3
ganeshsanap's avatar
ganeshsanap
MVP
Aug 07, 2023

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's avatar
    THough335
    Copper Contributor
    Aug 07, 2023

    ganeshsanap Thank you sooooo much for your assistance!  It worked.  Yay!

Resources