Sharepoint doc list review date

New Contributor

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 not seem to work.




3 Replies
best response confirmed by nqueen365 (New Contributor)

@nqueen365 Here you go!



@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.

@ganeshsanap is correct- my bad! my solution will work in a calculated column but not as a default value.