Forum Discussion

MC_Breadiness's avatar
MC_Breadiness
Copper Contributor
Nov 24, 2023

sharepoint calculated column

Hi I have two columns in a sharepoint doc library one called Next Review Date another called Current Date which is a calculated column defaulting to the current date.  I want to have a third calculated column that shows Review Status with 5 possible text outcomes,  In Date, due in 3 months, Due in 2 months, due in 1 month or overdue.

 

How can I achieve this with a formula in a sharepoint calculated column? 

No RepliesBe the first to reply

Resources