Forum Discussion

nqueen365's avatar
nqueen365
Copper Contributor
Jun 02, 2022
Solved

Sharepoint doc list review date

Need help with review date calculated value - Any advice on how to get this to work? I'm trying to have this auto-calculate to 6 months from modified by date. The formula I am trying does no...
Document Library
  • PamDeGraffenreid's avatar
    PamDeGraffenreid
    Jun 03, 2022

    nqueen365 Here you go!

    =DATE(YEAR([Modified]),(MONTH([Modified])+6),DAY([Modified]))

     

ganeshsanap's avatar
ganeshsanap
MVP
Jun 03, 2022

nqueen365 This is a known limitation of SharePoint. You cannot refer another column values while setting Default value of a column in list.

In order to use the calculated formula, your "Review Date" column must be a calculated column (not Date and Time).

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.

  • PamDeGraffenreid's avatar
    PamDeGraffenreid
    MVP
    Jun 03, 2022
    ganeshsanap is correct- my bad! my solution will work in a calculated column but not as a default value.

Resources