3 votes

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([...
Ganesh Sanap - MVP's user avatar
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 ...
Ganesh Sanap - MVP's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible