3
votes
Accepted
How to create a calculated column to pull the year of Date column 1, and if blank, pull year from Date column 2, if that's also blank then put Hold
Try using formula like below for your SharePoint calculated column (Year):
=IF(ISBLANK([Date1]),IF(ISBLANK([Date2]),"Review",IF(OR(MONTH([Date2])=1,MONTH([Date2])=2,MONTH([Date2])=3),YEAR([...
1
vote
Calculated Column next date
Unfortunately, this is not possible using SharePoint calculated column formulas.
SharePoint calculated column formulas does not support fetching values from:
Lookup column - single selection
Lookup ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
calculated-column × 1263calculated-column-formula × 493
sharepoint-online × 379
list × 263
date-time × 112
sharepoint-server × 111
2013 × 108
sharepoint-enterprise × 85
2010 × 80
sharepoint-designer × 59
custom-list × 56
modern-experience × 56
column × 45
lookup-column × 40
sharepoint-foundation × 39
workflow × 38
javascript × 36
date × 32
error × 31
list-view × 29
formula × 25
document-library × 20
2007 × 19
infopath × 16
designer-workflow × 15