SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
I have a column "Document Date" which is manually entered. I would like to create a calculated column that defaults to "Yes", unless it's 30 days after the document date in which case it automatically turns to "No".
Is this possible within the confines of calculated columns? or will this require a workflow.
I'm using SharePoint 2013 on prem.
I think I've found the answer for this.
=IF(DATEDIF([Document Date],NOW(),"d")>30,"No","Yes")
With The data type returned from this formula as: Single line of text
NOW() only updates when the item is saved/updated. So wait 24 hours and your formula is wrong: sharepoint.stackexchange.com/questions/151144/…
May 21, 2019 at 9:14